DSXchange

After the field is loaded into a Varchar max column...the data seems to be truncated (missing) - no more runtime error...but the data is missing...

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.

Yes - tried that...actually, that would further restrict the allowable size...

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...

What would be to syntax of ereplace to remove character set 0x1A?

Second question...Is it possible to reject the problematic Message into a file/table instead of just the 'warning message?

Thanks for the tip...however, ereplace() would only work if we knew or anticipated what the error was...no? Is there a generic function to zap bad characters?

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 ...

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...

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...

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

The actual date is not important, since all records are denoted by YEAR only. As for future dates...the job needs to 'open' up a set of records when a new year is acheived (ie. Dec 31 20xx).

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...

I agree with that approach, but how to code that physically into a job? IE, which objects to use within Datastage?

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...

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...