DSXchange

Hi Thanks, for the help.... got an another question... I need to generate target file with heading validation report... so can do this in datastage....or anyother ideas Validation Report column1 column2 column3 xxxxxxx xxxxxxx xxxxxx xxxxxxx xxxxxxx xxxxxx Thanks in advance... Sri Yea Ray I will acc...

Yea Ray I will according to you...... DSguru file should be sent via mail...... Yea I can use notification stage..... Thanks for ur help Sri A Link Collector adds unnecessary complexity, to my mind. You are seeking to perform seven separate operations. Make your design modular; use seven separate (a...

Hi Ray, Thanks ray.... I was looking to use link collector....where we can take seven inputs and target to .csv file.... and Is there any way in datastage or thru uinx i can send this .csv file after the ETL process is done....... Really appreciate ur help.... Thanks, How about seven different jobs,...

Hi Mujeebur Thanks for prompt reply.... EACH record is generated with diffrent sql and there are like 7 sql's with generate each record in the report And I was wondering what stage to use....? in between to source and target source is DB2 and target will be .csv format.. ROW1 we get from one sql ROW...

Hi DS guru's, how ya all doing..? well I got a question for u... I got requirement to generate a report and target should be in excel and the format is below... ROW# count diff AMOUNT ROW1 100 - - ROW2 200 - - ROW3 400 - - ROW4 600 2 1000 $ ROW5 300 3 2000$ ROW6 200 1 2000$ So, i know to get target ...

thanks brad for your promt reply..... the reason we switched to API is when we are using DB2 ENTERPRISE its not letting to connect to another server, by API we can connect to any server. And this jobs deals with 6 million records. I guess due to joins we are using in the query its taking long time, ...

Hi, wll there be any performance diffrence between DB2 API and DB2 UDB ENTERPRISE. cause recently i changed DB2 UDB ENTERPRISE to DB2 API in some jobs. before when the stage was DB2 UDB ENTERPRISE that jab used to take 4 hours but now when i changed to DB2 API its taking like 6 to 7 hours. can u hel...

hi kumar, its a production job i got that abort so i was kind of hurry..anyways looking forward i will follow according to you.... its just a single parrel job with out sequencer. does it matter's if we run the job using designer or director.... Hi Srikanth, Dont force to reply ASAP . Eventually you...

Can anyone tell me why i am getting this error

main_program: ORCHESTRATE step execution terminating due to SIGINT

i got this error when im running the job in production....can anyone u help me asap...really apprciate....

Thanks Andrew...these jobs are run thru autosys(dsjob unix script). but it load 90% of data into target table but last 10 percent it gave that status code = 80011. srikanth, How are you starting these jobs? If you start them through the dsjob command then you might have mis-spelled your project name...

hi wish u happy new year....well we ran some jobs in production it loaded all the data but the last 1300 records and it gave status code 0 but the last one it gave status code is 80011(u can see below). and i got another doubt whats the maximum jobs that can be taken into a sequencer(according to be...

thanks ray and Kenneth. yea i will find out Can you please ask your lead why this is required? And post the response here? A perfectly effective command line interface for DataStage is supplied - why re-invent the wheel? Logically the next thing they'll want is that you re-program all your DataStage...

i mean dsjob command can be submitted thru java. in my team i was the only ETL developer and my lead wants datastage jobs automated thru java. By java means you don't want to use the dsjob command line executable to start, monitor, and extra log and link metadata? You prefer to write your own versio...

HI can anyone help how to automate datastage thru java.my team wants datastage jobs submitted thru java process, is there anyway let me know. if there is way let me know where can i find the manual for that. its wud be appreciatable if u can help me ...