Search found 37 matches
- Mon Dec 30, 2013 6:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert/Update column value with special char #
- Replies: 5
- Views: 3103
Wow. I've rerun the job while testing some other issues, and now the #XYZ values are loading OK. I'll have to investigate to find out if someone changed my source or the table or the DS environment. Sigh. Thanks, chulett. I'll report back if I can find a reason for the change. Even if it's a ID10T U...
- Mon Dec 30, 2013 4:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert/Update column value with special char #
- Replies: 5
- Views: 3103
- Mon Dec 30, 2013 3:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert/Update column value with special char #
- Replies: 5
- Views: 3103
Insert/Update column value with special char #
I'm using the odbc connector to insert in a sql server table.
I'm trying to insert/update a varchar column with a value "#XYZ" and it is making the target column blank/empty.
Have a suggest on how to get the "#XYZ# inserted/updated in the target?
Thanks for your help!
Lynda
I'm trying to insert/update a varchar column with a value "#XYZ" and it is making the target column blank/empty.
Have a suggest on how to get the "#XYZ# inserted/updated in the target?
Thanks for your help!
Lynda
- Mon Mar 04, 2013 11:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Omit null columns in XML output
- Replies: 9
- Views: 5474
- Mon Mar 04, 2013 9:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Omit null columns in XML output
- Replies: 9
- Views: 5474
I was able to link the XML file directly to output the seq file. I set the seq file to Format 000 delimiter, 000 quote, set the line terminator to none, and I provided a single output column defined as varchar with / in the description column. In the XML stage, I turned off Comments. The resulting f...
- Mon Mar 04, 2013 9:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Omit null columns in XML output
- Replies: 9
- Views: 5474
Thanks, you all are very helpful! I don't have control over the project or server settings, but there must be a way to do what is needed. I'll go back and keep working, and I'll let you know if I find success. My last option is to manually edit the output files somehow. I may have to do this for the...
- Fri Mar 01, 2013 1:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Omit null columns in XML output
- Replies: 9
- Views: 5474
Thanks, Ernie. As an old time server girl, using Ereplace is pretty logical. Following through on your suggestion: I added a link from the existing XML stage to a transformer stage, and a link to another XML stage like so: <existing logic>-->XMLa-->Xfm-->XMLb Then in the transformer stage, I mapped ...
- Fri Mar 01, 2013 10:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Omit null columns in XML output
- Replies: 9
- Views: 5474
Omit null columns in XML output
I'm not too XML savvy, and I'm modeling this server job on existing jobs. And I apologize that my terminology may be imperfect, too. We are mapping multiple columns to individual output rows with tags assigned to each column value like this: <TransactionHistory itemId="205772" channelId=&q...
- Tue Jun 12, 2012 11:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Char 10 to Integer 10 gives unexpected results
- Replies: 11
- Views: 6462
- Tue Jun 12, 2012 11:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Char 10 to Integer 10 gives unexpected results
- Replies: 11
- Views: 6462
- Tue Jun 12, 2012 11:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Char 10 to Integer 10 gives unexpected results
- Replies: 11
- Views: 6462
When I tried to view the data using the ODBC stage, using CAST(input) as bigint, I can see the expected value. When I tried to view the data using CAST(input) as int and with the column defined as int 10, then view the data using the ODBC stage, it warns Maximum integer value exceeded. If I CAST(sub...
- Tue Jun 12, 2012 10:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Char 10 to Integer 10 gives unexpected results
- Replies: 11
- Views: 6462
- Tue Jun 12, 2012 10:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Char 10 to Integer 10 gives unexpected results
- Replies: 11
- Views: 6462
Convert Char 10 to Integer 10 gives unexpected results
My input is a SQL db column that is char 10 value 3600000008 I am trying to make the SQL db target integer 10 value 3600000008 I've created the correct results when sending output to a peek stage, using this transformation: AsInteger(input) But when I target the SQL db, I'm getting a result of -6949...
- Thu May 19, 2011 6:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lockout when updating rows using DB2 Connector
- Replies: 7
- Views: 4717
Have you installed the DataStage 8.5 Fix Pack 1? The doc makes it sound like it addresses some issues with the DB2 Connector.
http://publib.boulder.ibm.com/infocente ... 85fp1.html
http://publib.boulder.ibm.com/infocente ... 85fp1.html
- Fri May 13, 2011 9:31 am
- Forum: General
- Topic: IBM announces Fix Pack 1 for IIS 8.5
- Replies: 2
- Views: 2989