DSXchange

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

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.

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

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

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

Hi
I wanted to delete .dsx files in a temporary folder resides at DS Server using DS JOB.
Thanks in advance....

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.

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.

Hi Guys,
Can anybody explain what's the main purpose of RTI Services and where it is used.

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.

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

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

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

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

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