DSXchange

Can I call a unix shell script from Datastage job

We are having a column(Say SampId) of data type varchar(50)
Suppose the records are given as
1234567890121212
1234567890121213

The second record is rejected in the job for unique key.

When we take dsx form of the job and inport in other environmnerts,the job is getting aborted saying .'Sequence is not created'

We are calling a function to create a sequence in close command.In our environment it is creating the sequence and job isrunning fine.When we dsx form and change the environment,The job is getting aborted saying sequence is not created

when i an trying to populate data to a sdatabse table ,the job is aborting with error message as When checking operator: APT_ORACLE_LOAD_OPTIONS has been set by user. Therefore, Orchestrate assumes that the DIRECT and/or PARALLEL options have been set to FALSE, and that it is okay to load table 'TAB...

Hi Karthik,

can the same approach be used for parallel job

Thanks,
Karuturi

Thanks for ur gudence.I have to pose this issue in PX

we want to assign a value to job parameter.The parameter has to take max value of a key column so that we use this job parameter to used as stat value in serrogate key generator stage

Can anyone suggest an approach to what value should be given to start value in serrogate key generator stage in .we have need to take max value of key cloumn and increment from it

we want to assign a value to job parameter.The parameter has to take max value of a key column so that we use this job parameter to used as stat value in serrogate key generator stage