DSXchange

i want to run the job which iam designing. that means can i use this sub-routine and run the job. is that going to happen. That's what I was afraid of and why I asked why. No. You either need to run the job you've designed from the Director or create a Sequence job that runs the job via a Job Activ...

Simply moving it from a decimal to a varchar will 'convert' it for you. If you need something specific, throw a FMT() in there with it.

ps. Is this a Server question? DecimalToString is a PX thing, but you are in the Server forum and marked it as Server, hence the confusion...

vijaykumar wrote:i want to make use of DSRUNJOB job control subroutine.

Before we get too far into this, how about explaining why you think you want to do this? What kind of job are you thinking about running there?

kishoreramachandran wrote:I was told that the entries have been made for those two files , on my machine what should I do.

Find out the name that was setup for your connection and then just use that name in the ODBC stage.

Again, what is 'my machine'... your PC? If so then no you won't see them there or do anything with them there. Everything is done on the UNIX server where DataStage is installed. Assuming we're talking DataStage here and the ODBC drivers that come with it, yes? The ones you would use with the ODBC s...

What 'machine'? What are you trying to accomplish exactly?

ps. They are already installed, they just need to be configured.

There are size limits with certain stages and you've seem to found yours. I don't believe there is any way to change any settings to allow larger filesizes to be handled. Perhaps one other approach... We had one large chunk that needed to be included in every XML file (up to 400 per run) we generate...

You would need at least the 7.5.x version of DataStage so you had the 'latest' STP stage. Then you'd need to ensure the procedure was written to conform to the standards required for this as noted in the documentation for the stage.

No-one except gomers like us would use command line ftp from a Windows box.

Here, any business type folk who provide Excel csv files (typically) via ftp all use some sort of GUI package... and for that same reason we practically always get DOS files as a result. Go figure.

I haven't used that particular functionality before as the need for it never came up - and we do a ton of XML work. So, out of curiosity... Does this 'nested chunk' need to be included all at once in this manner? Or are there various elements of it that would match up with a set of keys in your inpu...

ray.wurlod wrote:Are you expected to bring back all rows that correspond to a partial match on all keys? (This was not stated.)

Actually, that was what looked like to me was stated, or at least to be inferred from the example given.

Parallel job is required as I am converting all server jobs into parallel jobs to improve the performance of the whole process. You'll actually decrease 'the performance of the whole process' by doing that. As noted, smaller tasks will be more efficient and take less time as Server jobs. And someon...

FTP can convert it, I wouldn't say 'does'. Way too many packages seem to default to a binary transfer which means you end up with a DOS file on your UNIX system. However, if you know that's what you are going to get why not just read it as a DOS file? Curious what's so horrible about using the DOS r...

Well... that would be how to set it, not what to set it to. I'd suggest a chat with your friendly neighborhood DBA man, see if they can shed any light on what it needs to be set to.

drostnu wrote:please if someone can give a hand if its a OS problem, DS problem, if i need to purchase something else from Ascential??

Ascential? The error message tells you what you need to get and from whom, even including an 800 number and a URL. Not sure what else you'd need.