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
Search found 67 matches
- Wed Jun 02, 2004 1:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Per DS project UNIX env variable
- Replies: 2
- Views: 2163
- Tue May 11, 2004 10:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UNIX pthread
- Replies: 2
- Views: 2305
UNIX pthread
Does Datastage and its programs (jobs) use UNIX pthread? I am using version 6 (server) on AIX 5.2. Thanks.
- Sun May 02, 2004 8:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SQL statement limit
- Replies: 2
- Views: 1997
SQL statement limit
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
Thx
- Sun Apr 25, 2004 11:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Clearing a multiple input hash file
- Replies: 9
- Views: 21995
Clearing a multiple input hash file
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...
- Wed Apr 07, 2004 8:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UDBLoad
- Replies: 14
- Views: 5838
- Wed Apr 07, 2004 8:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS Maintainence
- Replies: 1
- Views: 1728
DS Maintainence
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 ...
- Thu Mar 18, 2004 5:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DB2Load with DB2/EEE 7.2
- Replies: 2
- Views: 2167
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...
- Wed Jan 28, 2004 9:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage with 64bit environment
- Replies: 5
- Views: 2705
DataStage with 64bit environment
Does DataStage (Server version , any version number) supports 64bit AIX and 64bit DB2? Thx.
- Mon Dec 22, 2003 8:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Limit to number of multiple instance
- Replies: 5
- Views: 3288
Limit to number of multiple instance
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...
- Mon Dec 22, 2003 8:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Get All Jobs in a Particular Sequencer
- Replies: 4
- Views: 2409
- Tue Dec 16, 2003 10:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash file status
- Replies: 1
- Views: 1801
Hash file status
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
p.s. Thanks Kenneth for correcting me on the open command
- Tue Dec 16, 2003 10:04 pm
- Forum:
- Topic: Hsah file status
- Replies: 2
- Views: 1499
- Tue Dec 16, 2003 9:21 pm
- Forum:
- Topic: Hsah file status
- Replies: 2
- Views: 1499
Hsah file status
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?
In case the hash file is opened by another DS Basic program, can I lock the file for update?
- Mon Dec 15, 2003 4:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: MS Series & SAS Plugin
- Replies: 1
- Views: 1747
MS Series & SAS Plugin
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.
- Mon Dec 15, 2003 4:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: COMP-3 data with CFF Stage
- Replies: 1
- Views: 1502
COMP-3 data with CFF Stage
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 ...