Search found 10 matches

by kumarkb
Fri Dec 13, 2013 9:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implementing Transpose functionality in Datastage 8.5
Replies: 2
Views: 2420

Implementing Transpose functionality in Datastage 8.5

Good Morning Gurus, Following is my requirement Source Data ========== col1|col2|col3|col4 1|A|05-06-2013|15.6 2|B|07-08-2013|26.7 3|C|09-10-2013|37.8 4|D|11-12-2013|48.9 Target Data ========= col1|1|2|3|4 col2|A|B|C|D col3|05-06-2013|07-08-2013|09-10-2013|11-12-2013 col4|15.6|26.7|37.8|48.9 I tried...
by kumarkb
Fri Dec 28, 2012 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Connector View Data Error
Replies: 6
Views: 3942

We are directly working on 8.7
by kumarkb
Thu Dec 27, 2012 3:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Connector View Data Error
Replies: 6
Views: 3942

I tried changing the order i.e., 64 after 32 but still I am getting the same error.

LD_LIBRARY_PATH have the following
"/usr/lib:/home/db2inst1/sqllib/lib:/app/ibm/db2/V10.1/lib32:/app/ibm/db2/V10.1/lib64:/opt/mqm/lib64"

fyi
"/opt..." is for the MQ
by kumarkb
Thu Dec 27, 2012 12:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Connector View Data Error
Replies: 6
Views: 3942

DB2 Connector View Data Error

Hi, In our project DB2 setup was done 1 week back and to test the setup I designed a simple job (with only 2 stages) Reading from DB2 table using DB2 connector and target is Peek. This job is running successfully without any warnings and the data is logged in the director but the problem is that whe...
by kumarkb
Wed Oct 21, 2009 9:52 pm
Forum: General
Topic: How to replicate the REPLACE function of SQL in DataStage
Replies: 2
Views: 1882

How to replicate the REPLACE function of SQL in DataStage

Hi,
I have a feild in which the data is like 99,99,999.123
now i want to remove these commas and i want to make it as 9999999.123
Can any one please guide me...

Thanks & Regards
KB
by kumarkb
Fri Oct 16, 2009 2:39 am
Forum: General
Topic: Can i import 7.5.X version DSX into 8.x version of DataStage
Replies: 5
Views: 3174

ray.wurlod wrote:
kumarkb wrote:Are there any issues which might occur if i try to run 7.5.x jobs in 8.x ?
No.

Provided, of course, that all pathnames, database connections, etc., have been re-created. ...
thank you !!!!
once again... :)
by kumarkb
Fri Oct 16, 2009 12:30 am
Forum: General
Topic: Can i import 7.5.X version DSX into 8.x version of DataStage
Replies: 5
Views: 3174

Are there any issues which might occur if i try to run 7.5.x jobs in 8.x ?
i mean do i need to take any measures after importing them to 8.x ?
as per my knowledge there is not much difference in the stages of these 2 versions...

Pls guide me...

Thanks & Regards
KB
by kumarkb
Thu Oct 15, 2009 10:28 pm
Forum: General
Topic: Difference between DSX and DSX 7-bit encoded
Replies: 3
Views: 2660

Difference between DSX and DSX 7-bit encoded

Hi when i tried to export the DS job as .DSX i was able to see the below options
1) DSX
2) DSX 7-bit encoded

can any one please tell me what is the difference between these two?

Thanks & Regards
KB
by kumarkb
Thu Oct 15, 2009 7:19 pm
Forum: General
Topic: Can i import 7.5.X version DSX into 8.x version of DataStage
Replies: 5
Views: 3174

chulett wrote:Yes. ...
Thank you !!!!
by kumarkb
Thu Oct 15, 2009 2:43 am
Forum: General
Topic: Can i import 7.5.X version DSX into 8.x version of DataStage
Replies: 5
Views: 3174

Can i import 7.5.X version DSX into 8.x version of DataStage

Hi,
Can i import 7.5.X version DSX into 8.x version of DataStage ?
will it work ?

Thanks & Regards
KB