DSXchange

How can we use Routine to read those values in. If I store the N rows into a database table (in job J1), will I be able to read those values using Routines from sequence.

Here is my requirement :

I have a sequence MySeq that has job J1.

Now J1 produces N records (each containing say 5 columns)

Now based on each record column value, I need to call different jobs say J2,J3 etc in the sequence MySeq.

How to impplement that.

If I use UserStatus inside Job,how to assign value to that inside the job.

I need to run a Job from sequence.Then inside the Job, I derive a few columns based on which I need to fire different jobs.

Can I set some User variable inside a job then access them from the sequence.How to do that ?

How do we handle data from different locations (with different metadata) with schema files.Do we have schema file as parameter or schema file with RCP.

After that how to separate them into three fixed width columns

How to do that

Hi, I have the following fixed length input : Input : Q0009814 TEST DATA 500000P I would like to extract 3 columns from the below fixed length record file. Col1 - Q0009814 Col2 - TEST DATA Col3 - 500000P and I want to mention my Record Length = 40 and length of Col1,Col2,Col3 are 18,15,7 respectivel...

But in that aren't we removing the header (first) and Trailer (last) record from the input (seq file). In that case how we capture some header & trailer columns. It will require another job to use 'Head' & 'Tail' stages on the input file.

Please let me know what is meant by patterns :
sed '1,1d' and sed '$d'

Also how should I define the Seq file metadata .

I would like to capture a few header & trailer column along with actual records.

yes. How (using which stage with what all option) can we import data from a file that contains header,trailer information that is required in the job.

Hi,
How can we handle file with header, trailer (different metadata than actual records).

Thanks

I am using a ODBC Enterprise stage to connect to a SQL server.Now the operation I would like to perform is 'Delete then Insert'. The requirement is to clear the table then insert.But somehow I am getting error while doing that.I can do 'Insert Only' and 'Delete Only' separately, but not 'Delete then...

I meant that use of BASIC Transformer makes a PX job to run in sequential mode.

But I think BASIC Transformer is light weight compared to normal parallel Transformer.

Isn't that so.