DSXchange

I use DSJ.ERRNONE but that choice doesn't affect the attachment, only subsequent use of the handle. Have you tried actually using the handle in subsequent steps? From the docs: JobHandle is the name of a variable to hold the return value which is subsequently used by any other function or routine w...

The below code still returns an integer "0" in jHandle. when I pass the Job Name and Error Level as either DSJ.ERRFATAL or DSJ.ERRWARN.

$INCLUDE DSINCLUDE JOBCONTROL.H
jHandle=DSAttachJob(Arg1,Arg2)
Ans=jHandle

Chulett, Can you pls. shed some light for establishing a Job Handle to a given job? I tried calling the DSAttachJob function in a routine just to test it. Call DSAttachJob (Job_Handle,Arg1, Arg2) Ans=Job_Handle I passed Job Name for Arg1 and DSJ.ERRNONE and the Job_Handle returns an Integer "0&...

Chulett, Thanks for your quick response. I am calling DSGetStageInfo function in a routine just to test it. I passed the Job Name for Arg1, for Arg2 Stage Name and Arg3 Info Type (DSJ.LINKLIST) Call DSGetStageInfo (Result, Arg1, Arg2,Arg3) Ans=Result The value in the Result is a "-1". But,...

I'd like to extract the Input/Output link names in the same order as they are designed for each Stage in a give Job. example: sequential file-->transformerstage1(XX)-->transformerstage2(YY)-->DRS Sequential File Link is Input to transformerstage1 XX is the Output Link from transformerstage1 XX is th...

Hello Gurus,

I need help in extracting the Input and Output link names for a job using the Universe stage.

sequnetial file stage---> transformstage1 ---> transformstage2 ---> DRS stage


Any help with this is appreciated!

Can the Doctool (*.mdb) population (refresh) be automated the way reporting assistant within Manager does?

Aslo, is it possible to load the tables such as DSProperties, DSStages etc. in the doctool using the Universe stage?

Any help with this is appreciated.

Couple things come to my mind.. Here is what we did when building ETL architecture to load data from our Mainframe system (ADABAS). Refreshed ADABAS files from Mainframe into Oracle database by utilizing "Treehouse" tool and database triggers. http://www.treehouse.com/ The full refresh was...

Are the rows read from the source sorted?

order by Field1,Field2,Field3.

You will never get the comparison correctly if the source data is not ordered.

The routine has no restrictions on the length of the input string. Test the routine with sample data.

Can anyone please share how you were able to successfully install and configure Qualitystage on Windows? In preperation to next year ETL projects, I am trying to put together estimates to install and devlop of cleansing jobs using QS. We are currently on Windows DS 7.5 server edition. Also I will ap...

Thanks, Kim.

I appreciate you taking time for not only helping with the code but providing a great detailed explanation.

This will help me for sure.

I will appreciate if you post the rest of it.
Thanks

I am trying to write the Column Name, Group, Derivation, Key, SQL Type, Length, Scale, Nullable, Display, Data Element, Description detials to a file or to a table for all my table definitions in ODBC etc.. folders in Manager for one of my project. Just copying doesn't help. I tried Usage Analysis, ...

Thank you much all for all your replies. I will try both options.

I tried TCL run the following in Command Stage. But it is throwing verb not in VOC.

"COMO ON \\Server\directory\JobNames.txt, LIST DS_JOBS COMO OFF".

I am trying to load DS job names into a file.

Thanks