DSXchange

emma wrote:Thanks Kumar_s.

It works if we keep in mind that in Orchestrate environment a string starts with 0 not with 1 like in BASIC.
So, to extract first character must be:
record_type:string[1] = substring[0,1](record_data)

Just for document, In Transformer, it starts with 1.

Thanks ArndW. I got this code from one of the threads in the forum. Can i write a C code for generating the CRC. Is there a specific folder, that i need to store this code in. Can someone please provide me the code for the same. I am bad in writing a c code. :cry: I think you can write a C/C++ code...

Thanks all of you first.

ArndW,

I am using MKS for version control, however, as chulett said that

"It's not like text based coding where an intelligent source management system can help straighten out the mess for you"

Ray,

Where can I get more information about your mentioned tools ?

We have parallel development on DataStage job and would like to Sync source on DataStage job. However, it is found that it is not easy job. Case 1: I have a Job in project A, then export it as DSX (A.dsx) and import to project B, compile it in project B, and export it as DSX (B.dsx). The source shou...

Why not have a try on Filter stage ?

filter
-where 'STATUS = "Y" or STATUS = "N"'
-where 'STATUS is null'

Yes, my client is install in my PC. I am using v7.1, but can not found it in the installed directory.

Where can I get the windows version dsjob.exe ?

Would you please let me know when the environment variable $TMPDIR be used ?

I have a job generate so large file with name "APT****" in TMPDIR and final abort.

what a bad news !

I am using shell script to generate a generic DataStage job by OSH command. However, I encounter the following fatal error.

<main_program> Fatal Error: The number of outputs attached must be less than 128

Is it OSH command 's limitation ?

Does the reference table large ????? If it is not large, try to use vector to build up an internal table (in Pre-Loop), then loop with vector. Hello, I'm trying to write a buildop for the following requirement........I have an input stream which has 2 columns ProdID ProdName and I also have a rules ...

You may refer to your DataStage Client installation disk in \Samples\TrxExternalFunctions\, it gives you a sample to build Parallel Transformer External Function. Hi, We have recently jumped from Server Version to PX and have to migrate jobs from Server verison to PX. While reading the Pdfs in my un...

Could anyone tell the difference between Sort stage and inline Sort ? Have performance issue ?

Thanks a lot !

The path does NOT exist :<

rumu wrote:You will find it under Ruotine/custum folder.Try it using Manager.

rumu, thanks for your reply, but where can I find/call this routine ? Can anyone help on the following case. Thanks a lot!!! I have a date field and want to calculate the date after 24 month , does any function exist in Transformer or any other else ? Hi, There is a custom routine called "AddMo...