DSXchange

You need to determine why it didn't restart. Typically a port issue, see here for instructions on how to debug this.

That's Oracle behaviour rather than DataStage and looks like a localization issue. Double-check the NLS settings on both. Numeric formats are derived from the setting of the NLS_TERRITORY parameter but they can be overridden by the NLS_NUMERIC_CHARACTERS parameter.

What happens if you use dssh rather than uvsh? Probably doesn't make any difference but worth asking.

"It kills the performance" hasn't been true for quite some time.

You're welcome.

On import it just wants metadata, to know what the arguments to the procedure are - there's no "assignment" as part of this process. All of the assignment action happens when you call the procedure.

You can edit your original post and change the title. Short answer - you can't. Logs can be stored in either the XMETA repository or the legacy "Universe" repository but other than that you have no other control over it. An exact search here for RTLogging should find discussions on the dif...

I would assume you didn't source your dsenv file first.

The solution its very interesting.. Yes, it is. I was quite impressed the first time I saw this posted as it wasn't something that had occured to me to do. Basically, the first convert removes all of the characters you want to keep from your string, generating a custom list of all of the unwanted c...

waz153 wrote:I have made the required changes and used the routine as an afterjob subroutine in the job, but the file is not being created in the location.

Meaning what, exactly? It is being created somewhere else? Not being created at all? An error is being thrown?

... which doesn't preclude you from doing any of this from a shell script, btw.

I don't what all non-numeric characters might come so it will be better if we can have some transformation so that it contains only numbers from 0-9. OK. If you are expecting complete crap in your phone numbers then the old "double convert" trick may be in order: Convert(Convert("012...

That would be the DIGITS transform I noted.

I was wondering if I'd need to clarify that. The CFF stage is for reading the file but you first need to get the file from the mainframe to your ETL server, how you do that is completely up to you. Can't help with the specifics of your FTP question, can you take it to your mainframe admin and see wh...

There are a number of conversation here on that topic which a search for "jobinfo" may turn up. If you want to do this from the command line, look into the -jobinfo for dsjob. From a job, the DSGetJobInfo function would be the equivalent. You'd need to parse the last run date from the outp...