DSXchange

So just to be clear, you want to know how to generate a fixed-width file in an RCP enabled job, yes?

When I said "split the file" I meant using the UNIX split command rather than a job. Hard to be sure what you did but your mention of the "aa" "ab" (etc) suffixes make it seem you may have used it. Can you clarify? And we seem to be having the same conversation in more ...

Hmmm... not Resolved and I don't recall it ever being set. So... chaithanya - you may be new to DataStage and that's fine. We're perfectly happy to help anyone and have been doing so for years. But that help generally involves answering questions when people have problems or hints when people get st...

Good luck, not much people here can do to help on that one.

I for one wouldn't be using the routine to interface with a database. Why not simply pass back the information you get from the API calls and then use a DB2 stage to process them into your audit table?

I would take that to your official support provider, that sounds like a bug that needs patching to me.

Again with the posting of what seems to be a work assignment without questions or any evidence you've even tried to solve it. More of this 'testing' going on?

chaithanya wrote:I am a datastage trainee in my company. My lead gave this scenario to test my design capability.

And? What have you tried and what issues did you face? What questions do you have?

Sorry but at this point all it looks like you've done is post a work assignment.

Add some calls to DSLogInfo() after your sql statements run, right now you are doing ZERO error checking there.

Well, then... have at it!

We anxiously await your results.

I removed your re-post of this issue - please continue your conversation here.

Seems like an odd requirement. So you need to run the same job over and over, only processing 100 of the rows each time? Sounds like you may need to look into a Sequence job with the Start/End loop stages and job parameters to control the starting and ending record numbers that you leverage in a con...

We're over here discussing your question.

ps. I deleted the re-post you made over in the PX forum.

"In Oracle database" means what? Toad? I'll wager your tool is converting it from military time for display.

As noted, a DATE has no format but a date in a STRING does. Clarify for us what your source and target types are.

No idea but assuming you've checked to ensure that the database in question is actually up, then perhaps a network issue? And is this really "all jobs" regardless of what they do or only all jobs that source/target Netezza?