DSXchange

So, your 'OS' is really UNIX with error messages like that, yes? Also, what Oracle stages are you using in your jobs? Your dsenv file is not properly setup to match your environment. It's telling you it can't find the 9i Oracle client libraries. Double-check how your Oracle Environment variables are...

Either way would work. David's would run the jobs in a serial fashion, while Chuck's would run them in parallel... which would be faster as long as your job design will accomdate that. If you do, make sure the Sequence stage has its property set to 'All', by the way. If you have 7.5, the first metho...

You are problably just not specifying the proper directory when running dspackinst. It's been way too long since I've used it to last to add more than that. Why not just rerun your Server install? It will know you are not doing an 'upgrade' or 'new' installation of the software and go into maintenan...

I am a firm believe in "Thou Shalt not Abort Thine Own Job". As Roy mentions, there are several ways to determine if zero records were written to the file, via DataStage or your operating system. Then you can use those results to make decisions - do I run the next job in the series? Send out an aler...

Sorry, Oracle Boy should have kept quiet I guess. I get the impression "Sybase IQ" is different than just plain "Sybase", eh?

I don't see anywhere that the OP mentioned the FTP stage. As noted, the best answer is to do a binary FTP and then let the CFF stage do all of the dirty work. If you don't have it installed, why not take the time to do so? Rerun the server install and it should let you simply install any optional pl...

How is it defined in your input file? Are you sure that a binary ftp was used to bring the data to your server? You also can't do any kind of automatic EBCDIC to ASCII conversions during the FTP process as it destroys packed fields.

If you have access to Ascential Support, they'd be your best bet for "urgent" issues.

Try defining your input field as a CHAR(6) and then using the DataTypePicComp3 sdk routine.

Can you not use the Sybase OC plugin?

Sure, it's possible. It's a simple matter to issue a 'dir' or 'ls', whether you match a regular expression as part of it or look for all files, and capture the output. A call to DSExecute will do that for you. Then you can loop thru the output and do what is needed - check the size, run a job with t...

Well, here's an easy and painless way.

From the Projects / Command tab of the Administrator:

No need to do that, there's already a built-in Transform for that - it's called LETTERS. Note that there is also what is basically the opposite called DIGITS that uses "MCN".

DEVESHASTHANA wrote:if i am doing this then the job get aborting why is it so.

Hard to say without any specifics. Please post exactly what it is you are doing and the error message(s) you are receiving.

Spur of the moment.

Cool. Didn't mean to imply any level of doofosity on your part.