DSXchange

RobinM wrote:Old thread I know, but...

Could you use REORG DISCARD in your environment?

I am not familiar with this. Can you give me some more information about it?

Thanks,
Gaurav

Well, Header records counts will not be fixed...it will be changing.... here are some sample data from the file.... 1Q05 2Q05 3Q05 4Q05 06TGT Client Team TELE OO Fed/Exce GMR PUI 804Top Valid Revenue 8.926070 41.575685 12.089471 10.110442 06TGT Client Team TELE OO Fed/Exce GMR GS 804Top Valid Revenu...

Thanks for your quick response. There will be distinct header for each subset..... example, in a single file, I will be getting header1 ---------------> "1Q05", "2Q05", "3Q05", "4Q05" underlying Data1------> header2----------------->"1Q06", "2Q0...

Thanks Ray

Still I am not able find the solution. Wondering if I need edit properties for the particular column (decimal one)..

Regards,
Gaurav

Hello, I have 4 set of datastage job, which is running in sequence to achieve the desire target valus.... (1) DB2 -->xfm--> Datasets, (2) Datasets ---->join--->Datasets, (3) Datasets ---> join-->xfm---> Sequential file and then (4) db2 loader to load to target db2 database. When I check the Sequenti...

Thanks Kenneth for your guidance..

Regards,
Gaurav

How about creating a dummy column with a truncated & trimmed value from the LongVarChar into your target VarChar(315) in your SELECT statement directly? This would work for both Server and Parallel jobs. I have used Trim function for that perticular column in my x'former stage between source DB...

How about creating a dummy column with a truncated & trimmed value from the LongVarChar into your target VarChar(315) in your SELECT statement directly? This would work for both Server and Parallel jobs. I have used Trim function for that perticular column in my x'former stage between source DB...

kcbland wrote:Server or Parallel job, which stages (ODBC,CLI, PX?)

Kenneth,

I have tried both on Server and Parallel (in sequential mode). I have got the warning in my target stage which is DB2 API.

Thanks,
Gaurav

Hello, In my DataStage job I am extracting data from Japan MVS DB2 Database tables and load into the DB2 tables on Unix box. It's straight move. We dont want to export .ixf file first and then load to our target tables. Instead we want to load data directly from MVS database to target DB2 database t...

Well, with sequential files it behaves differently....

But when you use Datasets, it's partition based, u need to key partioned and sorted it before you input to ur join stage...

Gaurav Dave

Thanks Ray!!

Let me look on the Modify stage property...

Gaurav

Hi... In my job I m doing some aggregation, in which one of that is to find MAX value of the input field which is "CHAR" and contains Last name of the employee. And source is coming from flat files and o/p is also flat file. I have designed my job in PX enviornment, When I pass this column...

You can use a stored procedure. Here's how I'd do it in Oracle, you can figure out the method for UDB: declare max_rows integer := 1000; begin loop delete from mytable where mydate between begindate and enddate and rownum <= max_rows; exit when sql%rowcount = 0; commit; end loop; end; Great thanks ...

UDB is a different creature than Oracle, as a partitioned database it spreads it data around different notes in an attempt to distribute the data as evenly as possible. Partitioning by data ranges is not a common method, as data would group to specific nodes and therefore a single query could bottl...