Search found 37 matches

by lpadrta
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: 3027

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...
by lpadrta
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: 3027

Oops, sorry. :oops:

There's only one # sign. #XYZ is the value I want to insert.
by lpadrta
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: 3027

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
by lpadrta
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: 5346

Looks like the file produced from the sequential file stage omits the x="" and y="".

Mission accomplished.

Thanks all!
by lpadrta
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: 5346

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...
by lpadrta
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: 5346

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...
by lpadrta
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: 5346

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 ...
by lpadrta
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: 5346

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...
by lpadrta
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: 6326

For the time being, the rows that have data too large will have to be rejected until a fix is applied.

Thanks very much for your inputs.
by lpadrta
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: 6326

The only thing I can see is that the target is integer, length 4, precision 10.
by lpadrta
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: 6326

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...
by lpadrta
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: 6326

Thanks for the suggestion, SURA.

I found that I can use the tsql command to CAST the Char column to xml, bigint or sql_variant, none of which seems to be giving me what I need.
by lpadrta
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: 6326

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...
by lpadrta
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: 4636

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
by lpadrta
Fri May 13, 2011 9:31 am
Forum: General
Topic: IBM announces Fix Pack 1 for IIS 8.5
Replies: 2
Views: 2908

Has anyone installed IIS 8.5 Fix Pack 1 already?