DSXchange

Hi
Thanks for your replies.. I saw the previous post also.

Where to use the Sql option and how to use it?

Thanks
Madhav

Hi,
Is there is any way to get list of job names under a folder in a project.

I am getting list of all jobs by using
dsjob -ljobs <project name>

is there is anyway to add folder name too.

Thanks
Madhav

Is there is any ways to import stored procedure into a routine??

Yamini, I think ur trying sequential file as ur source and want to use the filter option which is provided next to filname properties. For the above case in the filter option use the following code sort -k 3,3 Further u should check this stage uses filter option in the stage tab. Basically above com...

Hi, We are basically writing into an Oracle Enterprise stage, source is Sequential file stage. We need to find out selected row count and seprate inserted row count and update row count into target table. I think GetlinkInfo function is not feasible option to achieve this.. as this gives only the ro...

First line column names advices Datastage that incoming sequential file has first row as column heading thus it will not be written in the target. Ex: Ur sequential file as the follwing contents Empno, sal 1,100 2, 200 3,300 In format tab if u check first line is column names the first row(empnno, s...

Hi,
Killbill1 i'll try ur option too.

Anrdw: dsjob - wait option throws me error like invalid arugument!
I don't find -wait option at all?

hey I tried sleep only..-wait option seems to be not working for me.. I tried like this, $DSJOB -run -param fname=CRGBNXTRCT06_01.txt -mode NORMAL $PROJECT_NAME $JOB_NAME $DSJOB -wait -run -param fname=CRGBNXTRCT06_02.txt -mode NORMAL $PROJECT_NAME $JOB_NAME $DSJOB -wait -run -param fname=CRGBNXTRCT...

Excellent it works fine..

Thanks
Maddi

In the log it says completed successfully.

FYI when I tried running the each DSJOB command one after another in the command line.. It is executing successfully!!

Hey, I used the following script... PROJECT_NAME=beacon_dev JOB_NAME=TRY_STGTgbCGRndBItem DSJOB=$DSHOME/bin/dsjob $DSJOB -run -param fname=CRGBNXTRCT06_01.txt -mode NORMAL $PROJECT_NAME $JOB_NAME $DSJOB -run -param fname=CRGBNXTRCT06_02.txt -mode NORMAL $PROJECT_NAME $JOB_NAME $DSJOB -run -param fna...

Hi, We are going to have a simple job which loads from a sequential file to a Oracle table. But the problem here is since the volume of the records is more the data is splitted to n number of chunks of sequential file. Basically we are trying to develop a single job and parameterizing the source seq...

Hi,

I am getting this warning when i run a parallel job.
The jobs uses oracle enterprise stage..
itz a simple job which loads (direact mapping) from source to target.

Warning is:
Failed to connect to JobMonApp on port 13401

Can anyone help me out to resolve this issue.

Thanks in advance

If you run multiple jobs at the same time how the same sequential file is updated if you go for single sequential file?

Hi
Can we have list of parameters in a file
and pass the file as a parametere to this routine?

It would help me to have a centralised file and change the list of parameters as when required