DSXchange

Thank You Arnd & Ray!!!
I will work on Arnd suggestion to get what I required.

That is true ArndW but that would also remove line breaks between each output row as well which I need to keep.

Thank you ArndW!

I can easily filter it but I still need the complete message text as one line input to my looping logic in the UNIX script.

Thank you Ray! I am not a premium member but planning to be one very soon. Would you mind suggesting the alternative for my requirement so that below sql works without any line breaks for each row it returns irrespective of log message length. SELECT EVAL "FIELD(MSG.TEXT,CHAR(253),1)" AS E...

RT_LOGxxx has a multi value column MSG.TEXT with output depth of 60T. What would be the maximum length between two value marks? This is required to determine FMT format value to get the text in one line without any breaks. Below statement works as expected when number of characters before the first ...

Thank you Ray! Object code inspection gets me the dependencies with use of UNIX pattern scanning commands. $DSHOME/bin/uv "VLIST RT_BP${job_no} ${object_file}" Kim, We move only executable code from DEV to UAT/PROD . The code movement is a combination of ClearCase and UNIX daemon script wh...

Hi, After much of investigation I found that I can not get sequence job dependencies if 1. Only executable is imported in the project without design time components and 2. Dependencies tab in the job properties is not properly populated because of copy/paste of objects before generating exeutable co...

Thanks a lot Ray!!! It works, modified SQL is as below. $DSHOME/bin/uv "SELECT EVAL \"IF MSG.ARGS='' THEN MSG.TEXT[5,LEN(MSG.TEXT) - 13] ELSE MSG.ARGS\" FROM RT_LOG21 WHERE TYPE=5;" Is there any easy way to get invocation id from RT_LOGXX file? Or is there any direct way to get e...

Hi, The requirement is that for all control log entries success/failure/aborted/reset I need the MSG.ARGS populated with jobname.inovationid if multi-instance job else jobname. Currently for every aborted entry MSG.ARGS is empty. Below query works for me to get the jobname.invocationid from the RT_L...

I have already tried the option of writing BASIC routine using DSGetJobInfo() but the only setback I realize is running this basic routine standalone on the UNIX command line of the DataStage server so that I can loop it through all the 50 projects. Please guide me with an option if I can run the BA...

Thank you very much Ray!!!

Do we still have an option to query the Universe database to get this list of stages from executable of a DataStage job?

Note: RT_CONFIG file happens to be a difficult choice for me to get this list

Thank you very much Ray!!!

Do we still have an option to query the Universe database to get this list of stages from executable of a DataStage job?

Note: RT_CONFIG file happens to be a difficult choice for me to get this list

Hi, I have a requirement to list all the stages active/passive for all server or parallel jobs in each project. The blow query works good for me but it returns ZERO records when I hit a job without the design time information. $DSHOME/bin/uv "SELECT NAME FROM DS_JOBOBJECTS WHERE STAGETYPE NOT L...

In the log it is showing the whole sql query only after that hanging

At the beginning of the select query