DSXchange

More details, does it make any sense, that this type of error could come up because the Oracle installation was done from user=OracleUser(NOT from Administrator), but DS Server was installed from Windows Administrator??? Any ideas? Instead of editing the previous(old) job,Try designing a new job an...

Replace the NULL values to a default value then do the comparison.

You(User Id you are using) need to have atleast Read access (on the Database) to view the data from any data browser in DataStage.It holds the same for any other database tools.

Hi, I am creating a hash file with 3 million records and its following error: "HASH_DW_GRID..HASH_DW_GRID_APIGG.loDW_GRID: DSD.UVOpen mkdbfile: cannot create file /vol02/home/dsadm/hash/DW_GRID_APIGG" This hash file job was running successfully till yesterday and no changes has been made ...

I know how to run the job from command line. can any provide to schedule entire project using Unix Shell Script. Please provide me Unix Shell Script to Schedule a Project. Because i am new to Unix.Pls You may find the answer for your question looking at this script. http://groups.google.lt/group/co...

Ray/Nick,

I've figured it out. Thanks though !

Can you be more clear on this.........

Ended up spending too much time on this ... : column1 varchar 13 column2 varchar 4 column3 varchar 9 column4 varchar 6 column5 varchar 5 column6 varchar 10 (watch your last record ... has less spaces) In the format tab: Record level --> Record length = fixed Field defaults --> delimiter = none Fiel...

chulett wrote:

pradeepleon wrote:It isn't a fixed flat file.Have you got this resolved?...If not reply....

How do you know this? Sure looks like it could be to me. Usually one would know or be told by whomever provides the file, you shouldn't have to guess.

You are right chulett I guessed it after a few trials....

I am trying to read a flat file in a Seq file stage. Snapshot of flat file. 012345678901 890 89012345 12456 259 1489.236 012345678901 901 90123456 12 458 12545.454 012345678901 012 01234567 0123 589 154505445 012345678901 123 12345678 11111 145 021425450 012345678901 123 12345678 10.20 5.23 1256.12...

DSguru2B wrote:Whatever goes wrong with the job, it will be logged. You can get the log entries by various options of dsjob command. Namely -logsum, -logdetail, -report etc. Look into them.

Thanks!
I'm actually working on the same.

If you're just talking about getting what is produced in the dirctor log into a flat file, run an 'After Job Subroutine' Routines\Built-In\Before/After\DSJobReport It has instructions on how to use it in the routine description section. If you want to get all errors detected within the job by your ...

Welcome Aboard There are numerous error that you can encounter on a flat file using the sequential file stage. File permissions, metadata problems to name a few. I suggest spending a few hours going through file related problems on this forum. What do you mean by logical errors though, it passed me...

nick.bond wrote:Did you mean 'How to capture them in a flat file' ?

Yes exactly

Hi there,
Can anyone suggest me of capturing all runtime errors and logic errors of a job on a flat file?

Thanks
Pradeep