DSXchange

Thanks for the reply ...

it seems a long way I was hoping to see some ORCHADMIN command or some thing like that...

I will check more options if you know any shorter way plaese let us know...

Thanks

Hi

Is there a command like dsjobs -lstages to find out what all datasets are used in a patricular job.

Example : If job A has 3 data sets a,b,c

output of command be like

Job A a
Job A b
Job A c

Thanks in advance

DSrecords command works

Thanks

Hi Is this "orchadmin describe -d -l <your dataset file> " is what I use in a transformer ? We want to have this is some job like we will pass a list of datastets to it and we need to put dataset name and the record count in each into a file with two columns FileName and RecordCount. from ...

Hi

We need to read a dataset and get the number of records in it and write it into a file

Is there function or system routine or some command which will help me achieve this.

Thanks in advance

" param ParameterSet.Param1= value " part did the trick, it works.

Thanks a lot

We will try this option and let you know if it works... Thanks for your responses

I am looking to command line which will pass the parameter set a set of values and use the generic job and after it finishes use another paramenter set values for to run the same job.

It will be great if you can give me a syntax to use.

Thanks

Hi Gurus, We have paramenter sets defined for a datastage job which does a generic CDC, we pass parameters of table names and connetions and all that good information. From datastage when we run we select the parameter to be passed and run. Now we have to do it autosys so we need a command line synt...

[quote="dsnovice"]In server there is Oconv with MB Option.. in Parallel you could try using the encode/decode stages..

Thank you,

a novice[/quote]

We are on parallel edition

Hi All,

Is there a function in Datastage to convert binary into int format

let us know
Thanks

[quote="ds_developer"]You can find that type of information in the JOBCONTROL.H file that is in the dsinclude directory of the project.

John[/quote]

Thanks a lot John, I found what I needed.

[quote="ray.wurlod"]There are thousands of error codes. Your database documentation should have a manual that describes them, and probably has a utility that decodes them. For example the Oracle utility is the [b]oerr ...[/quote] we have DSJS.RUNOK routine which gives the status of the job...

Hi, When the Datastage rejects some rows based on the erros in data types or data overflow etc, is there a way to capture those reject code and description why it is rejected. How many different reject codes are there... is there some place in where I can find all that information. I want to populat...

Hi I want to post this as a working document and also as reference for many like mw who are curious about commonly used commands. Please help me and others sharing vast knowledge you all have. COMMANDS 1. to delete a job via command DELETE FROM DS_JOBS WHERE NAME = 'JobName' 2. clear hash or delete ...