DSXchange

use one stage variable to find out how many spaces are there in Full Name(how many words) using the count function

then you can use Field function accordingly

You can insert Env variable. $ENV_VARIABLE there are no '#' . there must be some other error, like a missing ':'.

thank you,

The routines DSGetJobInfo(), DSGetLinkInfo() and DSGetStageInfo() are data stage given routines. these are much better way to get information. and they will not hinder performance. This is kind of a standard practice in most places. One way of implementing this is to use a multiple instance job with...

Make the update job a multiple instance job. And you can call the job with instance name as the sequence name. If Sequence a is calling it then the update job will be updatejob.a at the same time updatejob.b can run. you dont have to worry about scheduling

62962 dsadm 2574 2573 0 Jul 14 ? 0:12 dsapi_slave 8 7 0 46727 dsadm 18809 18808 0 Jul 06 ? 0:02 dsapi_slave 8 7 0 dsapi_slave 8 7 0 usually refers to client application like Director or Designer that are open. As these client applications constantly chat with the server to report any changes or upda...

I would try Oconv(Iconv(%Arg%,"D-YMD"),"D-YM[4,2]") .

IHTH,

Novice

Hi ken, My associate tried the following command > GRANT SELECT,INSERT,UPDATE,DELETE,DROP ON Hsh_ECRM_CON_ACCT TO User1211; and he got "DataStage/SQL: DROP unexpected" how ever he is able to assign other priviledges like select, insert, update,delete on UV table. by the following command G...

Please go through the Serve Guide as Sequencer is still a server component. Basically you can select the Jobs from your repository and drop it on the SEQUENCE template. Then Connect these two jobs with the link starting from the First job you want to run and ending at the second job. Then you can go...

*****FileSjob..XFORM_MERGE: |*****FileSjob..UV_MERGED_FILE.inMerge: DSD.BCIOpenW call to SQLExecDirect failed. DROP TABLE "Hsh_ECRM_CON_ACCT" SQLSTATE=42000, DBMS.CODE=950563 [DataStage][SQL Client][UNIVERSE]DataStage/SQL: You don't have enough privileges to DROP "Hsh_ECRM_CON_ACCT&qu...

If the incoming excel file has only one sheet, no extra blank sheets and there are no special formatting. Then, you might be able to open it using sql file stage with delimiter as 009 (tab). Some times you would have to specify the file format as Dos if your ftp process doesnt take care of convertin...

Kim, All the SQL you gave me worked properly, I just had to customise it for my environment. Initially I used the index sql to find the index number it turned out to be 12, hence the 12 th field of record holds the parameters of Execute command. Then I used the below sql in uvsh prompt to extract th...

Kim,

Thank you for the codes I will publish my methods and approach at the earliest.

thank you,

a novice

Ray, neither the done files nor the wait for files are parameterized. it is a good suggestion we will implement it in the future. Kim - Will your DwNav will be able to provide this info? I noticed you and Ray are the top posters when it comes to hacking the backend of DataStage. I tried extracting i...

Hello, In the Job sequence level we use Excecute Command to create done files. These done files act as check points for other sequences by the wait for file activity. Our problem is we have lot of sequences and cross reference of the file, now we want to compile a list of done files created by each ...

Ray,

I tried to replicate the error - I was unsuccessful. I guess its one of those blue moon errors. I will definetly put full details of the error if it occours again.

Thank you,

novice