About OraBulk, Auto Purge, Schedule, Hashed File

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

About OraBulk, Auto Purge, Schedule, Hashed File

Post by admin »

Hello.
I am sorry that I cant English well.

I wonder following that.

1.
In ORABULK stage, I want to set "Data file field separator : tab". How?

2.
In DataStage Administrator, I set about "Auto Purge".
where does AutoPurge Content save?
Manaully, can each job be set about AutoPurge?

3.
In DataStage Director, I scheduled one job. And on unix terminal, I view schedule content using following command, crontab -l I edited schedule using following command, crontab -e, and in DataStage Directors schedule view, I view old schedule still. Where does DataStage schedule Content save?

4.
I want display only hashed files in TCL.
I do next sql statement, SELECT * FROM VOC WHERE TYPE = "F"
How can I see that it is hashed file or not and what is its type among 1~19?

Thanks.
Locked