Search found 47 matches
- Thu Jul 18, 2019 10:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar(max) SQL Server
- Replies: 5
- Views: 5068
- Tue Jun 04, 2019 5:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varbinary(max) - SQL Server
- Replies: 0
- Views: 2504
Varbinary(max) - SQL Server
Trying to read/write Varbinary (max) data from and to SQL Server database.
There is error reading the source column...(no rows returned) when there is data in the table.
There is error reading the source column...(no rows returned) when there is data in the table.
- Wed May 29, 2019 9:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar(max) SQL Server
- Replies: 5
- Views: 5068
- Wed May 29, 2019 2:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar(max) SQL Server
- Replies: 5
- Views: 5068
Varchar(max) SQL Server
Trying to write source column Varchar(max) to target Varchar(max) in SQL Server. There is error stating mismatch column length/size with truncation of data... I have tried writing into SQL using LongVarchar (setting array sixe 1) but the error persists. Some incoming rows exceed the 8000 character l...
- Tue Jun 05, 2018 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML - Xalan error
- Replies: 4
- Views: 3896
- Fri Jun 01, 2018 12:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML - Xalan error
- Replies: 4
- Views: 3896
- Mon May 28, 2018 8:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML - Xalan error
- Replies: 4
- Views: 3896
XML - Xalan error
I am getting sporadic errors while processing XML messages from MQ Connector. The structure is: MQ -> Transformer -> Copy Stage -> XMLInput -> DB table. `Xalan fatal error (publicId: , systemId: , line: 1, column: 3606): Invalid character (Unicode: 0x1A) 1. I've read that Datastage internally might ...
- Wed May 16, 2018 1:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Warnings
- Replies: 1
- Views: 1997
XML Warnings
I have a Job that reads XML messages from MQ Connector. All potential fields/columns are mapped to a target table. However, some elements (most) are nullable and sometimes do NOT appear in the XML (tns header and element text() is missing)... In this case, Datastage would show a warning: " [col...
- Thu Apr 26, 2018 12:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Recursive XML
- Replies: 1
- Views: 2032
Recursive XML
Hi I am trying to parse out an XML that has recursive list embedded in a lower level. However, the Edit Assembly does not show the recursive elements (aliased with <> plus an infinity sign). The recursive list STARTS at 7 levels deep within the XML...but I only need to parse the 1st level of the rec...
- Thu Mar 24, 2011 11:24 am
- Forum: General
- Topic: DSGetJobInfo
- Replies: 1
- Views: 1909
DSGetJobInfo
Hi,
I am trying to capture Job statitics (Run Start Time and End Time). The job is an Execute Command activity (to call a shell script) in a Sequence Job.
How do I capture these statistics? Via a Server Routine? Parallel Routine? Server Job/Transformer?
Thanks!
I never
I am trying to capture Job statitics (Run Start Time and End Time). The job is an Execute Command activity (to call a shell script) in a Sequence Job.
How do I capture these statistics? Via a Server Routine? Parallel Routine? Server Job/Transformer?
Thanks!
I never
- Thu Aug 12, 2010 8:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating new rows of records.
- Replies: 12
- Views: 6388
- Wed Aug 11, 2010 12:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating new rows of records.
- Replies: 12
- Views: 6388
Hmm, okay - let me rephrase my example. Let's say I have a file (100 records). A subsequent requirement is to create a new file by adding a YEAR column into the file and also creating yearly versions of the file. The base year is 2009. So the original file has 100 records and the year column is adde...
- Thu Aug 05, 2010 11:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating new rows of records.
- Replies: 12
- Views: 6388
- Thu Aug 05, 2010 9:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating new rows of records.
- Replies: 12
- Views: 6388
The concept of what is to be acheived is correct, however, there is a bit of logic to determine when the next bucket (or calendar year) is to be created. Example: for historical calendar years, I can use the logic you've mentioned below, but for 'future' ie switchover from Dec 31, 2010 to Jan 01, 20...
- Thu Aug 05, 2010 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating new rows of records.
- Replies: 12
- Views: 6388
Generating new rows of records.
I am trying to manipulate 1 set of records (file) and expand it into multiple records separated by a Calendar year. Example File Name:Description:Date Paul:Engineer:Jan-04 Stacey:Director:Feb-05 Richard:Janitor:Dec-06 Required File Name:Description:Date:Year Paul:Engineer:Jan-04:2008 Paul:Engineer:J...