Not sure if this will help but I needed to use the following command in the transformer when loading a binary value through DS:
Iconv(MappedColumn,"MX0C")
Apparently, DS converts binary to the numerical equivalent without this command.
Search found 17 matches
- Mon Feb 14, 2005 12:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SQL Type Bit to Binary Data Conversion Problem
- Replies: 9
- Views: 6108
- Fri Feb 11, 2005 12:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Random abnormal termination of jobs
- Replies: 11
- Views: 5901
Double that on the Windows version. We've been experiencing random terminations for the last 8 months. Last night 3 jobs failed with this error or similar: jb000PlyrSessionGroupALL6.9.Copy_of_Link_Partitioner_62.ww: ds_ipcopen() - call to OpenFileMapping() failed - The system cannot find the file sp...
- Fri Feb 11, 2005 12:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date type??
- Replies: 2
- Views: 1514
- Fri Feb 11, 2005 12:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Connection Error
- Replies: 7
- Views: 3351
Problem solved
Ascential support informed me that I needed to use the "start" command prior to the "rcmd" command. Worked flawlessly. :D
- Mon Jan 31, 2005 12:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Connection Error
- Replies: 7
- Views: 3351
- Thu Jan 27, 2005 3:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Connection Error
- Replies: 7
- Views: 3351
It's actually tring to connect to \\bgepiphany. \\bgedwapp02 is the server that DS is running on. I've logged into that server and fired off the batch file using our service account and it runs fine. There's always a possibility that I'm missing something and a different account is being used. I wil...
- Thu Jan 27, 2005 12:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Connection Error
- Replies: 7
- Views: 3351
Connection Error
I'm trying to use DataStage to fire off a separate vendor's ETL process. I've generated a batch file that successfully fires off the job successfully. However, when I use the "execute command" stage in DS to fire off the batch file I get the following message: Epiphany_Launch_Test..JobCont...
- Mon Jan 10, 2005 10:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generating GUIDs in DataStage
- Replies: 3
- Views: 2274
Generating GUIDs in DataStage
I've read the recent posts on this topic but have not seen a clear answer either way. Is there any way to pass a SQL generated GUID to DataStage? When I attempt this I just get a "0." Any advice would be greatly appreciated.
Bill
Bill
- Thu Jan 06, 2005 4:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Activating NLS
- Replies: 3
- Views: 2383
- Thu Jan 06, 2005 11:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Activating NLS
- Replies: 3
- Views: 2383
Activating NLS
It seems that we need to turn on NLS. We've been running without for about a year and I was wondering if there was anything I needed to be aware of before turning it on (i.e. recompiling jobs, new options, server reboot etc.)? There is no specific language need, it's just that to use nchar or nvarch...
- Fri Oct 15, 2004 7:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ds_ipcopen() error
- Replies: 2
- Views: 1862
- Fri Oct 15, 2004 2:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ds_ipcopen() error
- Replies: 2
- Views: 1862
ds_ipcopen() error
I've seen others post the same concern but I have never seen anyone with any resolution. I have a stage using a link collector with multiple (under 64) streams coming in. I'm getting the following error on several jobs: b000PlyrSessionGroupALL4..Link_Partitioner_62.DSLink13b: ds_ipcopen() - call to ...
- Thu Oct 14, 2004 11:00 am
- Forum: Enhancement Wish List
- Topic: Smat Compiling
- Replies: 0
- Views: 2276
Smat Compiling
Allow users to choose a "top level" sequence to compile and have DS compile all jobs and sequences below it.
- Fri Oct 08, 2004 11:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple Streams to a Single SQL Bulk Loader
- Replies: 1
- Views: 1018
Multiple Streams to a Single SQL Bulk Loader
We seem t obe expreiencing intemittent data loss using the SQL bulk loader. One factor the might be contributing is that we have multiple streams of data feeding into the bulk loader stage directly. Has anyone seen this problem before. I am open to changing jobs to load multiple strams into a link c...
- Fri Sep 24, 2004 2:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NETWORKIO lastwaittype in SQL Server 2000
- Replies: 4
- Views: 1889
Network traffic should not be a problem. We've looked at our network usage through the NIC on both ends and we don't go much past 25% usage. We've also been monitoring overall bandwidth and have not been exceeding any major thresholds there. My next step is to move the job over to the other appserve...