DSXchange

Hi All, Please help me....!! I have a requirement like below I have two files 1. DATA file 2. MAPPING file in DATA file I will be having the data for a particular customer and its length of 3000 and it has N records in MAPPING file I will be having mapping information for DATA file i.e. it will have...

What is DRS stage ?? where and why we use that stage...
i never came across that in my datastage version

Mahi

Hi
Can I use the funtion DSGetLinkInfo to get the informations of link variables like Value of a particulor variable.

Note :My job always returns me one record for each execution.

Mahi

Iam trying to call a db2 stored procedure from odbc stage with set of parms to get the results sets back In a COBOL Stored Proc results are returned by opening a cursor defined using the "WITH RETURN' option. In the Stored Proc: If an SQL SELECT statement is executed BEFORE the result set curso...

Hi All, Iam calling a db2 stored procedure from odbc stage with set of parms and am seeing some strange errors I am able to call the stored procedures with the parms from input file and getting the result set back to datastage job successfully...... but If the problem use two or more selects then th...

Hi All, I have defined a job with 2 job parameters and my requirement is ineed to pass these params from a seq file. my seq file will have 2 fields which needs to be passed to the above JOB. Could you please tell me how to achieve this.... i have searched the forum but i could not find proper answer...

Thank you very much Logic for your reply I am still wondering about Stored procedure stage whether it supports or not....!!!! my company bought DS license 2 months back( and they should have bought latest version only!!!!!!!) but stored procedure stage not working for me. when i open stored procedur...

Hello Friends,
I would like to know whether datastage 7.5 will support stored procedure stage for DB2.

from the available manulas i could find this supports only Oracle Currently

Is it true please let me know....


Thanks
Mahi

Hi All, We are working on re engineering ETL project(mainframe etl to datastage) existing code was develped in mainframre using lot of cobol +db2 stuff. Now management planning to chnage the entire application to datastage. and they decided to reuse some of critical cobol+db2 stored procedures in da...

Hi All, could you please help me for my qustion... Do we have any facility to kick a datastage job automatically when a extract file comes into one of my project unix folder i.e i need to trigger a DS job A when ever a file transmission to my unix folder...?? Please provide some info or link to manu...

Hi All, My datastage designer project folder connected to a folder A under unix so if i write DS routine to read unix file under folder A it is opening/reading with out any problem...... Suppose if i tried to access different file from differnt folder say folder chcprov am not able to access......i ...

Thank You Very much Ken, But am new to unix and i never wrote shell scripts...but iam intrested to learn and know abt how to use them in datastage....could you please guide me or any link to manuals also fair enough...please brief me about using shell scriots in datastage and when we actually use th...

Hi All, We just started working on datastage for an reengineering project. we will converting one of our mainframe application to datastage. and Our project manager decided to use some of existing stored procedures in the new datastage project and we have couple of stored procedure and i would like ...

Sorry All, I have confused some of you by referring emp mgr files. I have two files and there is no direct relation btw them but i need to processing each record on 1-input file using a set(all) of records on another file 2-input file. The set of records on the second file are not 'linked' directly ...

Hi All, I am new to datastage please help for my requirement!! My requirement is like this Ex: I have a input file say emp file where i have some 10 employeerecords and i have another input file say manager file where i have 5 records i have to process each record on 1 input file(emp) using a set of...