Search found 77 matches
- Mon Mar 28, 2005 3:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to generate control files in a datastage job?
- Replies: 8
- Views: 6849
Hi ArndW Can i write code like this in after job routine? Result= DSGetLinkInfo(DSJ.ME,<<stageName>>,<<LinkName>>,DSJ.LINKROWCOUNT) and my doubt is how to create control files with rowcount information and transfer it to particular location in DataStage server. i can use ftp,but how to generate cont...
- Fri Mar 25, 2005 4:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to generate control files in a datastage job?
- Replies: 8
- Views: 6849
how to generate control files in a datastage job?
Hi,
I have a requirement in such a way that i need to generate control files, one should contain no of rows extracted and another should contain no of rows loaded and both the files should put at remote server location through ftp.
Thanks in advance.
I have a requirement in such a way that i need to generate control files, one should contain no of rows extracted and another should contain no of rows loaded and both the files should put at remote server location through ftp.
Thanks in advance.
- Thu Mar 24, 2005 4:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how could we convert the the data in binary to char
- Replies: 2
- Views: 1022
- Thu Mar 24, 2005 2:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how could we convert the the data in binary to char
- Replies: 2
- Views: 1022
how could we convert the the data in binary to char
Hi i have extracted the data from DB2 Database through ODBC Stage, but most of the fields datatypes are binary. how could we convert from binary to actual char format at the time of extraction itself. for more info, DB2 Database resides on AS/400. i think this may be a problem with the ODBC interpre...
- Tue Mar 22, 2005 11:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: what exactly this error meassage says?
- Replies: 2
- Views: 1625
what exactly this error meassage says?
Hi i'm trying to import a ODBC table definition where the table is from DB2 Database. but unfortunately i got this error meassage "DSR.MetaGeta[GET.TABLES][SQLCONNECT[LMS,'Aoppsol']]:BCI :Error SQL STATE=S1000,CODE=7680[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]User...
- Fri Mar 04, 2005 5:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do you delete files in particular directory using DS Job
- Replies: 3
- Views: 1616
How do you delete files in particular directory using DS Job
Hi
I wanted to delete .dsx files in a temporary folder resides at DS Server using DS JOB.
Thanks in advance....
I wanted to delete .dsx files in a temporary folder resides at DS Server using DS JOB.
Thanks in advance....
- Wed Jan 26, 2005 10:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: shall we extract the data through JDBC driver?
- Replies: 3
- Views: 1086
shall we extract the data through JDBC driver?
Hi Guys,
I have a requirement such that i need to extract the data by connecting through JDBC Driver but not through ODBC.
Is there any option like that in DataStage Server Job.
I have a requirement such that i need to extract the data by connecting through JDBC Driver but not through ODBC.
Is there any option like that in DataStage Server Job.
- Tue Jan 11, 2005 12:17 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Can anybody explain about DS RTI Services and purpose &
- Replies: 4
- Views: 4522
shall we extract the data from PDF Files through RTI?
Thanks for your information...
i have a doubt that shall we extract the data from pdf files by using DS RTI and load it into particular database like oracle or DB2.
i have a doubt that shall we extract the data from pdf files by using DS RTI and load it into particular database like oracle or DB2.
- Sun Jan 09, 2005 11:15 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Can anybody explain about DS RTI Services and purpose &
- Replies: 4
- Views: 4522
Can anybody explain about DS RTI Services and purpose &
Hi Guys,
Can anybody explain what's the main purpose of RTI Services and where it is used.
Can anybody explain what's the main purpose of RTI Services and where it is used.
- Sat May 22, 2004 2:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: when merge stage can be used exactly?
- Replies: 3
- Views: 1459
- Sat May 22, 2004 12:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: when merge stage can be used exactly?
- Replies: 3
- Views: 1459
when merge stage can be used exactly?
Hi when i try to merge two input files(fixed length), the job is aborted with follwing warning DataStage Job 2154 Phantom 1648 Program "DSP.Open": Line 122, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage empdept..Merge_0 DataStage Ph...
- Thu Apr 01, 2004 5:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: splitting 950 lines to each Header and Line Items
- Replies: 3
- Views: 1381
splitting 950 lines to each Header and Line Items
Hi, i have requirement that i need to split 950 line items for each Header record according to business logic where source file contains millions of records. eg:- suppose a transaction may contains 1000 line items and the logic should go as follows:- H Z-101 K012 L 2345.56 4567.89 Y 2004 013 C0060 L...
- Sun Mar 14, 2004 9:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to run a Server job by setting a row limit
- Replies: 3
- Views: 1326
How to run a Server job by setting a row limit
Hi guys.... :D i wanted to know how to run a job by setting row limit. i am running a job where source(database table) having 70 lac records. i wanted to check first 100 rows how the records were transformed to target. is there any constraint or predefined command to limit the rows while passing to ...
- Fri Mar 12, 2004 3:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do we capture duplicate records
- Replies: 11
- Views: 5575
I would be more specific this time all columns have same values throughout each record. eg:- extracting Source table corpcode location account project cfis 55020 AB000 7897890 NULL NULL 55020 AB000 7897890 NULL NULL 44578 NL789 2345566 kpaccc NULL 44578 NL789 2345566 kpaccc NULL destination table Lo...
- Fri Mar 12, 2004 2:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash File Problem...
- Replies: 11
- Views: 2724
lot of convesations went .. good. All given perfect information on how to tackle hashfiles. i think you have not selected correct key fields in HashFile. Key fields whatever there in Source should have to match in Hashfile also. Here i'm listing some points below while comparing or poplating the dat...