DSXchange

Hello,

Is it possible to set the unix env per DataStage project in DS version 5.2.1 instead of setting for the whole engine (in dsenv)? Thanks a lot.

Regards,
Dick Fong

Does Datastage and its programs (jobs) use UNIX pthread? I am using version 6 (server) on AIX 5.2. Thanks.

We are trying to put am update SQL statament in the DB2 Plugin stage and found that there is a limit of the number of characters in the SQL statement. We didnt find the exact number of char limit yet. Has anyone ever encounter the same issue and are there any work around on that?

Thx

I have a simple job which has one input stream from a sequential file. A transformer which takes in the source and have mulitple lookup hash files attached to it. The logic is simple but it would output data to the same hash file when matching different lookups. What I need to do is to clear the tar...

I have the same experience too. I am curious if this is the case for version 6 / 7. Any idea?

Sometimes, for whatever reason when the DataStage client (Designer) disconnected from server accidentally (like system halt) the job that the client is working on would be locked, when I check the server with command netstat -a | grep ds I see connections from the client in CLOSE_WAIT status. Since ...

As we tested, it does not work. Autoloader for partition database (EEE) is not supported in DS. If you need to use autoloader, you would have to create a specific configure file for it. The bulkload stage only support the traditional 'LOAD' command of DB2. You can consider v8 EEE for which normal 'L...

Does DataStage (Server version , any version number) supports 64bit AIX and 64bit DB2? Thx.

Are there any limit to the number of multiple instances fired for a job? I have a script wrapper job which wrap a UNIX script. This job is set to allow multiple instances. Then I use a job sequencer to call this job 60 times and passing different parameters to it. Just like you call a UNIX command w...

If your jobs has been ran at least once, you can simply execute dsjob command with -jobinfo parameters to all your jobs. Then write a little script to grep for the "Job Controller" and you shall get all the jobs called by the given controller (sequencer). Hope that helps

Given I use OPEN to open a hash file to file variable FVAR in DS Basic, how can I detect if the file is opened successfully?

p.s. Thanks Kenneth for correcting me on the open command

Sorry but I just realized that I am posting to the wrong forum. Sorry for any inconvenience cause.

Given I use OPENSEQ to open a hash file to file variable FVAR in DS Basic, how can I detect if the file is opened successfully?

In case the hash file is opened by another DS Basic program, can I lock the file for update?

Any one can share experience with the captioned plugins? Something like what to take precaution, performance, version support, etc. Anything would be greatly appreciated. Thanks in advance.

Hello, We are using CFF stage to code convert our host data (EBCDIC) to UNIX (ASCII) for transformation. According to the COBOL definition, COMP-3 field with '0d' should be marked "-ve" sign. However, we found that CFF returns "+ve" values Is it a bug in CFF? Or do we understand ...