DSXchange

Hi,
You need not import your new table definitions into datastage from TEST schema after you have moved the jobs from Dev to Test enviornment.

You should able to run your job from TEST enivornment after moving from DEV - VERSIOn CONTROL - TEST.

Ketfos

Hi,

I am sure if the word ASAP were not mentioned in your post,

you could have got well defined answers to your post from different members.

Ketfos

Thanks Craig and Ray for sharing this mystery of terms and numbers.

Ketfos

Hi,
i wrote a job exactly as mentioned in the initial message.

It worked fine.

My output file name was defined as

uv/Projects/workfiles/x*.txt

The file was populated correctly. Input was Oracle table.

Ketfos

Hi Dssidhu,
What is meant by 1 Cr Records.

Pl clarify.

Thanks
Ketfos

Hi Phil,

Can your share your function of handling nulls in seq file?

Thks
Ketfos

Hi Ray, What I noticed after I read your note - I put a constraint "Abort after Rows = 10" When I run the job, it aborts and director log shows Aborting after 10 Rows written to CustUpd.TransDtl.DSLink4 THis is correct? But No rows are populated in the table in which the constraint is set ...

Hi,
I donot have personal experience in using DataStage like tool in real time enviornment like the airline systems you mentioned.

Base upon my readings, I can suggest you to look into Teradatta and Pervasive software System.
Both of them have been used in the Airline Industry.

Ketfos

Hi,

What is your defnition of real time enviornment?

Ketfos

Hi,
Why are you not able to use max function? Any reason or error you get.

Ketfos

Hi,
Use the max function

select max(date_column) from table_name

Ketfos

Hi,

It could be that you may pass characters into number variables or your variable size is not enough to hold the value.

Ketfos

Yes, Truncate did bypass the trigger.

Ketfos

go ahead and do it.
Ketfos

Thanks Ken.

I noticed I had a delete trigger on the table. It prevented the deletion of the rows.

Hence Clear Table and Insert Row (Update Action) works correctly in DataStage.

Thanks

Ketfos