DSXchange

Can DataStage coordinate a unit of work that exists on mainframe and open systems? Here is what I am trying to ask... Let's say you have a job that is going to remove records from a mainframe DB2 table and insert them onto an open source Greenplum table. So you might have a job design that does some...

Yes, strange request. But here is the business sense?! We have fields defined really large and our customers want a file in the length that their systems support... they know the data will never really be that large and just don't want to make any changes on their side. So, they want us to feed the ...

The reason for doing it with a schema and not a transformer... is that we are attempting [/b] to write a generic job that gets any data off the mainframe DB2 table and build a schema file from DB2 tables that supply the formatting rules... I thought about this over the weekend and I think I'll have ...

It it a valid COBOL PIC clause. I created a COBOL cfd file... 01 TRYIT. 05 TRY5 PIC x(5) JUSTIFIED RIGHT. and imported it into Table definitions/COBOL file when I went to the Table Definitions Layout tab, parallel here is what it showed me: record {record_format={type=implicit}, delim=none, ebcdic, ...

I have a DB2 connector to a Sequential file stage. I want to be able to take a Decimal field that I get from a DB2 query and have it in the external file as string with the leftmost characters truncated. Example: 123456.12 show as 345612 with no decimal point and right justified. I only want to use ...

FIELD1:nullable DECIMAL[9,0]{null_field='000000000',padchar='0'};

Tried this... no luck.

I have a simple parallel job with a DB2 connector stage and a sequential file stage. I want to bring in a schema file in the sequential stage so I can override some things as it is exported. I have a field that is nullable and is defined as DECIMAL[9,0] on the source. If this field is nulls I want i...

That did work but impacted performance. Any other thoughts?

DB2 Error -254 = A NON-ATOMIC statement STATEMENT ATTEMPTED TO PROCESS MULTIPLE ROWS OF DATA, BUT ERRORS OCCURRED I have a parallel job with 2 (DB2) Connectors and a reject link going to a sequential file. In the first connector I am selecting off the data I want to extract from the source table. In...

Got it to work!

Had to add the "as"...

SELECT "Customer Number" as custnum
, "Customer Name" as custname
FROM SCHEMA01.MEMBER;

Message Id = IIS-DSEE-TFOR-00165 My job is a very basic DB2 connector connecting to an open systems DB2 systems; running SQL contained within a file. The result of the SQL query is written to a sequential file. Within the SQL, I am accessing data from a DB2 view. This view has column names that cont...

I can't get the link to Kim Duke's website to launch... is that the correct link?