DSXchange

You can't with DataStage out of the box, true. A script is not the only solution however, a custom routine could be written to do this.

You either need to convert to string, concat and then convert back or multiply the decimal by 100 then add 1.

Hmmm... why does this sound familiar? Because you've already asked this question.

Still curious if these are the actual files stored as CLOBs in the database or are they pointers to the phyical file? From what I've seen most databases support both concepts, hence the question.

:!: Please do not continue to run around and jump on the end of anything you can find that you think is related. I've deleted those posts and added the details for you in this post. I'm having the same error message but before it I get the "ORA 0006 deadlock detected while waiting for resource&...

You will need to clarify what exactly it is you mean by "text files on the database". Specific examples would be nice, as well.

Can you post the actual 'correction' that you did? That would help other people searching for the same issue.

Perhaps helpful:

viewtopic.php?t=150119

Going to need a wee bit more information than that to be able to help you. I split this post out from the five year old one you jumped on the end of - is your error related somehow? Regardless, we'll need the details of your error please. And next time, please start your own post when needing help w...

Yes, for a loop you can use 'the same job' as long as it doesn't use a wildcard but instead passes the filename in as a job parameter each time.

The stage supports a wildcard pattern so you could do them all at once. If they need to be loaded individually (one at a time) build a looping Sequence job.

No clue. Can you give us some context? This is coming from the Sequence job at what point / from what stage?

And to complete this, you also cannot import a higher versioned export into a lower versioned server.

Interesting. You could also conditionally write out the header record as well if desired.

Try an exact search here for "MetaStage_Loc_Info" and see if anything that comes up helps.