DSXchange

Guys I would appreciate your views to implement this logic. Basically I am trying to come up with a process to handle cleansing and confirming during the ETL. I am thinking to have a DB2 table(as our database is DB2) to store our cleanse and confirm rules and do a lookup to this table in DataStage t...

Peter

I am not sure about routine. But I have done this using Bat script.
If you want I can share you the code. If you write a batch script you can also include that in your datastage designer as a utility so that the functionality is one click away.

Thanks

I don't think we need to do that. I tried concating two dsx files into one and imported it which worked fine.

Thanks

I guess concat should work. let us know.

Using the same command answer is NO. but you can accomplish what you want with the help of small batch file.

Thanks

This is client command. DataStage does not need to be on windows.
This works even if DataStage server is in unix. But we need to run this command from client machine.

Thanks

Well said...This is made like paysite as it reaches 10000+ members and they forgot that it reached that number because this was a free. Just to let them know that there are other sites available for datastage where we can see the replies by becoming memeber.

Syntax is as follows:

DSExport /U=%UserName% /P=%Password% /H=%Host% /JOB=JobName %Project% FileName

Thanks

Kumar I do not know how to paste images here. Yes. Our source is Mainframe VSAM files. Particular section of the copybook has the redefines in it. so I am trying to route them to different output links. since the source has hexa decimal values I am using CFF stage as my source stage to convert them ...

Ray

I am not pushing anyone to answer my question nor I did mention urgent anywhere in my post. I have been reading this forum for quite sometime now and I know the do's and dont's. I was just wondering if I was not clear with my post. I know the cost of urgent too...

Thanks

DSExport command can also export individual jobs.

Thanks

I am looking for answer from someone ? Am I not clear in my question ?
If so please let me know.

All I have a question about CFF stage. My input file has redfines clause. so I am using CFF stage and entering values in ID FIELD and VALUE field of redfined fields in the selection criteria. For Example I specify COL1 as ID_FIELD and specify the VALUE as 100 for first output link, 200 for second an...

Guys I am using Merge Stage to do full outer join(complete set) of two text files to find add, delete and updates. I am getting this following error. Link property retrieval error I did set up the temp dir. Any one have clue ? In this forum few posts say that performance will get affected if we use ...

Thanks Arnd and Ken ! I tried Ken's idea and it worked. Then I was trying to use Arnd idea of pipe for performance but ran into problems. It simply hangs if I don't use timeout's and fails if I use timeouts. Read the forum again and as per some one's suggestion I broke the job into two streams and i...