DSXchange

They haven't posted in a couple of years, so we might be out of luck here. First guess would be a missing stage type in the new server. Any chance for some optional one the old job uses that doesn't exist in this new environment?

First guess would be you ran out of space. Evidently.

I cannot use the substring function to elimimate the st, rd ,th and filter out digits Sure you can... it won't be fun but it can be done. You can use Field() to pull the day and then month/year out of the date and then you'll know the last two characters of the day can always go. Pad out the remain...

Well... perhaps you could explain to us what "view the data without using metadata" means to you? What are you trying to accomplish? To me it means going out to the command line and using vi on the file. Or doing the same with a hex editor. Or perhaps defining it as one long string field i...

They are either wrong or not using it in the same fashion that you are, i.e. in a transformer. In either case - choose another name. One standard is to use a prefix, jp_JobStatus for instance, which would help here.

Exactly. In other words you have to replicate the steps that the Job Activity stage does for you automatically... thankfully, it's a pretty straight-forward and simple task.

If you do investigate and get the actual limit, please post it back here.

As to the "workaround" that would typically involve creating a view that implements your wordy query and then sourcing from the view.

Of course there's a limit but I can't help on the DRS stage, you'll have to ask IBM for that information. If it helps, here's what I found out some time ago for OCI so it may give you some ideas. http://www.dsxchange.com/viewtopic.php?t=130306 And just so you know, "words" is pretty meanin...

Done.

I said "formats" not "functions", if you clicked a little deeper you'll find them. And there's nothing magical about this, just do it like you would with any other date using DateToString().

Sigh... that's not any kind of "ftp" and about the worst way (IMHO) to transfer files between disparate operating systems. Best to stick with generating the file using "DOS" record terminators if you are going to go that route. And you don't need a "UNIX terminal" to do...

It's in the Parallel Job Developer Guide pdf, search for "%ddd" or "Date and time formats". In my version that starts on page 31.

And... ? Just trying to make sure you understand what happens when you FTP a file in either binary or ascii mode, so you don't have unexpected issues when you do it. As noted in the previous link, if you type "ascii" before you do your manual "put" the transfer will automatically...

Nothing I've posted has related specifically to the FTP stage as I've been assuming a manual ftp all along. Hence the link. The other assumption is your FTP target is a Windows system. Is that true? If not, you'll need to change your record delimiters in the file when you create it rather than when ...