DSXchange

Hi, When I am running the below script in Job control, File1 is created but no records ideally it should have 1000 records, I don't know why awk script is not taking parameters. A =1 B =1000 when I am passing this parameter to below FileBack = "awk 'NR==A,NR==B'":" ":FileName:&qu...

Hi, We have 100 extract Jobs (Reading Seq file and dumping to oracle) in our env but we have to run jobs when corresponding file appears in Unix box. We may have 1 file at a time in unix box so we have run only that job once second and third file appear we have to run corresponding job. Can you plea...

Ray, srry that was writing mistake offcourse it should be another variable.

Ray, what i understand from you is If i have to read DS_JOBS file i have to use only Pk Column. Let me know my understanding is right or not.

open DS_JOBS to file else
call ..
end
read file from file, ID (This is the Job name)

I have tried this and it works.

Thanks
Ashish

I know how to do this via Universe Stage its is very simple, but i am making a complex job control which could do everything in a single shot, please help me with the read command syntx , i have tried but it didnt wrk. Ray one question, If i wanted to read a non key column then what i hav to do. Tha...

I wanted to open DS_JOBS file and store the jobs name in one variable I tried open 'DS_JOBS' to file else call ds.. end I dont know how to read particular column from this table and store it in a variable. DS_JOBS : has JOB Name , category etc i would like to store JOB name in a variable. how to do ...

Hi,

Can anyone tell me how to open universe tables throught JOb Control and store the values in Variable.

I want to store all jobs belong to particular Job category in a variable.

I have tried but i am not familiar with the syntax. can anyone help me on this

Thanks
ashish

Hi Ray

Thanks for your response

It was syntax error, its wrking fine now.

Thanks
Ashish

Hi ray,

There is only one Next statement i.e Next i

where you can see second next statement?

Thanks
Ashish

Hi,

I am writing arguments one by one

OpenSeq <File_Name> to var1

For i=1 to 2
WriteSeq i to var1
on error Call<>
Then Next i
Else CloseSeq var1

Error:
Next i ^
"NEXT" unexpected, Was expecting: Array Name, Variable name,

Please suggets

Thanks
Ashish

Hi I have one routine whose result is below, I need to capture the Result in other JOB. Please suggest me the answer how to do that. TEST #1 ******* Arg1 = JOB_XFM Arg2 = Arg3 = Test completed. Result = ************************************************** STATUS REPORT FOR JOB: JOB_XFM Job start time=...

Hi, I would like to take the all passive stage information from Job A and would like to print all passive stages in the Director Log of Job b. I have created a Job control but it is not giving the correct answer The below Job control I have written in Job B * Setup JOB_A, run it, wait for it to fini...

I got the same error? please suggest what to do next.

Hi, when compiling a server job using transformer there is no issue but while compiling a parallel job using transformer getting an error. Compiler and Linker setting in admin APT_LINKER - /opt/aCC/bin/aCC APT_COMPILER - /opt/aCC/bin/aCC APT_COMPILOPT - +DD64 -O -c -ext-z +Z APT_LINKOPT - +DD64 -b -...

ray.wurlod wrote:How do you know when one of these feeds is ready? That is, what would trigger DataStage processing? ...

There is one Trigger file called X.X ones it appear in the directory, DataStage Jobs kick off.

Let me know if you need more information.