Search found 77 matches

by pongal
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...
by pongal
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.
by pongal
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

ArndW, I am connecting DB2 at remote site, so it may not be possible for me to post DB2 table dll file. Here is the structure of the table F8903 Field Datatype Length eg:- Correct val GMMCCU Binary 24 340334033403340334033403 'TM" GMMLDA Binary 6 463046374638 some chars GMM01A CHAR 30 INSURANCE...
by pongal
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...
by pongal
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...
by pongal
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....
by pongal
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.
by pongal
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: 4521

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.
by pongal
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: 4521

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.
by pongal
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

Thanks Ray...
u given valuble info. that i never faced this kind of problem.
i have reset the job and corrected temporary directory path and also output column datalengths and run the job successfully. :)
by pongal
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...
by pongal
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...
by pongal
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 ...
by pongal
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: 5568

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...
by pongal
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...