DSXchange

It isn't a director bug, but the way in which windows assigns permissions to the remote folder or even maps that folder. To check that, just change your copy command to use a local folder and you'll see that runs OK from a job.
Are you using the same userid when running the DS job?

Mohan, this question has been asked several times before here in this forum. The DataStage engine is a cloned copy a database system called UniVerse which now also belongs to IBM. The two are still very similar and have only had a couple of years to grow apart - the core functionality remains the sa...

Hello Mayankrakesh and welcome to DSXChange. ..3. The txt file is being opened in Notepad and being saved as UTF-8 encoded file.... There is no need to do this and it might cause some issues, particularly as I don't trust MS Notepad to do this correctly. Just read the file into into DataStage and sp...

Now I'm confused, in your previous post you stated

ecclesr wrote:I have just run a test with a sequential file after the collector stage

No issues
...

Did you mean that the Windows delayed write was turned off or that it had something to do with the database?

If it runs when writing to a sequential file but "hangs" when writing to Oracle then isn't it logical to look at the OCI stage as the possible source? In your original job if you were to put a sequential stage between the final transform stage and then write from the sequential stage to the OCI (kee...

This is not an error message, but an informational one. This means that your job uses one the SDK routines that keeps track of sequences; and that this was the first call to the routine in which it created the file.

The first question is where are you looking for the statistics and not seeing the results you expect? Designer, Director? Log files? dsjob call?

Hello Randy and welcome to DSXchange, DataStage has, as part of the package, a full programming language called DataStage BASIC which is almost identical to the UV/BASIC language in UniVerse (mentioned because there are a lot programs and documentation available out there on the internet for this). ...

I'm not 100% certain, but there are 3rd party tools that will let you do "rsh" or similar command from a host to UNIX box to let you trigger off jobs.

I had noticed the DSJ.ERRWARN key does that when I used it in the past and never really gave it a second thought. It does make some sense as this routine can be called from a program that is not running as part of a job so the log of the job being opened is a logical place to put the message. If you...

Craig - he is getting a warning that his job has no active stages. His job has no active stages.

jhmckeever wrote:...Arnd...J.

I don't know if I noticed anything wrong, since so many Windows machines now have MKS toolkit or similar extensions and thus the "rm" command is pretty much standard.
Are we going to meet next week??

1. For the remote machine, use "del" as that is guaranteed to work in Windows.

2. The warning about no active stages is correct - the FTP stage is a passive stage.

Greg, does PX do any better if you input the data as a string and then convert to double precision? It might be that the loss of precision can be avoided by doing that.

Port 31538 by default, but you can change that. Try using the search facility using the keywords "port number"