DSXchange

You will get a unique number (checksum) for each input. This is used for several purpose, for example, duplicate check, dedupliacation, Surrogate key generation, lookup.... You can easily get more information by doing a search on the same keyword. A unique number fo each input? Nope. Useful for sur...

A 'nondelimited one field file' could also be generated as a 'Fixed Width' file simply by checking that option. Same thing. You'll still need to set the quote character to '000'.

Or as noted, specifically concatenate all fields into one big one.

mdtauseefhussain wrote:i tried with concatenating %h%m%s

Yes, exactly - case sensitive. Who said anything about using '%h%m%s'?

It is working fine ,but i try to open or to move the file i am getting the error Encountered 1 error during the transfer How exactly are you 'opening' or 'moving' the file? At this point you are done with DataStage so you need to take your problem to your SAs, your SysAdmins. Tell them what's going...

Does the date need to be a job parameter? Or can the counter be the job parameter and you use it to lookup the date inside the job? If it needs to be a parameter, then look into the User Variables Stage and its documentation - that's exactly what it's for. Or write a job that takes the counter and l...

Do i need to select multiple instance for the two jobs along with the sequencer If the same job (of any type, server or sequence) needs to run more than one 'copy' at a time, then you need to 'select multiple instance' for it... whatever 'it' is. how to pass the parameters to the job. Have you trie...

mdtauseefhussain wrote:I need to concatenate time stamp along with the date

If you are trying to say that you don't know how to add a time portion to the already provided date solutions, it's just this:

How exactly have you done what you have done? Meaning how / where is this loop implemented? That will help drive the answers. If you are using the Loop stages in a Sequence job, why not pass in the current counter value as a parameter and use it against a hashed file that contains the 'BeginDate' fo...

Guess the banishee just needs to outlive the banishers.

kcbland wrote:I'm an idiot, never mind, it's only for Oracle.

While the original version only supported Oracle, the version in 7.5.1A supports Oracle, DB2 and Sybase. So still no SQL-Server but not just Oracle no more.

Either Ray is a fan of Phil Mickelson... or he just said a dirty word - just ask him!

In case people weren't aware or hadn't noticed it on their 'front page': THE ASCENTIAL DEVELOPERNET WEB SITE WILL BE SUNSET AT THE END OF JULY 2006. THE CONTENT OF THESE FORUMS WILL BE MIGRATED TO THE IBM DEVELOPERWORKS USER FORUMS. REGISTRATION TO IBM DEVELOPERWORKS IS FREE OF CHARGE. TO ENSURE UNI...

Why would you post your Sequence job code? For the points? If anyone wants to see something like that, simply check the 'Code' tab of any Sequence job in your library. And I agree with Ray - it's generated code for goodness sake, not all that pretty but certainly not 'out of control'. Or all that ha...

You... could. It (the database work) would run much slower, however, so keep that in mind. All that really buys you that I can see is the fact that your hashed file would be in sync with your database in the event of an abort, and it changes your restart/recovery process. I prefer to not do it that ...

There's no reason to 'commit for each insert'.