DSXchange

In other words, by skipping the 'T' separator.

To what end? What are you planning on doing with this information?

If your target is a plain text file, then there's no way to do what you need. What are you expected to output with this formatting / color - Excel? HTML? Something else entirely?

OK. Have you involved your official support provider yet?

Sorry, while I've worked with unbound Oracle NUMBER fields and had to play the whole '38 v. 40' game, never had a time where the internal number was large enough to overflow the 38. Wasn't quite sure from your post if you are having trouble with the number itself transferring OK. Does it transfer fi...

Add that $APT environment variable to your job parameters and then override it there to 0x20, which is a space.

Make sure you understand the difference between doing it at the individual job level (affects just that job) and making it at the Project level which will affect all jobs.

Nope... corrected.

What exactly do you have in the stage now? All you executed was "type" without any filename, hence the error.

What database? Autosys?

Don't have the docs here with me, but the API function to get parameter values (DSGetParamInfo?) should have an InfoType to get the value used in the most recent (last) run. Can't go any further back than that without farming the logs but the function should get you what you need.

Well, crap, wish I had noticed that. You're right, that other one would have been more appropriate, I just picked the first one I stumbled across. D'oh.

Please don't post the same question in multiple threads, let's just stick with this one, shall we?

You will get a sequence generated for every unique 'name' you pass in. I generally use the target table (or sequence) name.

Yes, but with the 'multiple jobs, same table, same time' requirement, make sure you use the 'Concurrent' version.

Please let us know the exact version of DataStage you have and the details of your job design: structure, stages used, settings, etc.