DSXchange

I am using the sql of /dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT DISTINCT SUBSTRING(DTM FROM 1 FOR 10),REASON FMT '50L' FROM UNNEST DS_AUDIT ON MODS WHERE INSTANCE='jobname'GROUP BY REASON,DTM SUPPRESS COLUMN HEADING COUNT.SUP NO.PAGE;" and I want to limit this to current date. /...

Thanks Ray. It worked.

Hi From a project , if suppose I want to find out the list of jobs that are updated for current date for any reason , is there any way I can do that ? I am actually trying to get that from DS_AUDIT table ,but failed to compare the 2 data types of DTM and CURRENT_DATE in uv Sql. Can anybody please he...

Hi When I am running the uv queries , I am getting some page breaks in middle of the Results and it resulting some 20 results from the table and asking to press any Key for Continue. Can Anybody please help me in finding out a way to get all the results on the same page or how to increase the Outcom...

Thanks Craig....This really works . Thanks a lot.

Thanks for your Quick response .

Actually even though I was selecting only the names of the jobs it was returing the categories .So I was just wondering like , will there be any other way to overcome it .

I will then try the other way around per your suggestion.

HI All Is there any way we can find out the list of jobs that are in a specified Category and store the result in a file . I have tried command : /dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT NAME FMT '50L', CATEGORY FMT '200L' FROM DS_JOBS WHERE CATEGORY LIKE '%Playground%' COUNT.SUP ;&...

Hi I am working on creation of a buildop which stores all the records from the input into memory .Here by I am using the code like: readRecord(MainInput.portid_); while(!inputDone(MainInput.portid_)) { // Transfer column values from the master_in link to the master_out link doTransfer(0); OutLink.IN...