Search found 22 matches

by smithasri
Mon Jul 12, 2010 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: legacy Stage
Replies: 1
Views: 1116

legacy Stage

Hi Friends,


Please provide some information about legacy stage in Datastage.

Thanks
your friend.
by smithasri
Thu Jun 10, 2010 8:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setup MQ connection
Replies: 1
Views: 1248

Setup MQ connection

Hi Friends, Currently I am using MQ connector on datastage 8.0.1 version with these paramters( queu manager, Channel name,Connection name,Queue name). It is working fine. The issue is now: MQ team changes the process ,they are providing only channel table(exnaple:AMQCLCHL.TAB) instead of channel nam...
by smithasri
Wed Feb 24, 2010 9:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove string from string
Replies: 10
Views: 3475

Thanks ray for your comments. it was diffcult issue for me. not every one . I tried with all options after that raised question in forum. note: Character by character is not possibile for me, becuase we will multiple characaters. please post your thoughts if you any faced this issue. Thanks friend
by smithasri
Wed Feb 24, 2010 6:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove string from string
Replies: 10
Views: 3475

remove string from string

Hi Friends, I am searching for remove string from string. Input remove string output OFDSGH GH OFDS GFSRPVDS SRDS GFPV CRSR SR CR This is my requirement, I tried field and index functons , but i don't acihve out. Please provide me some help Thanks Friends
by smithasri
Tue Jan 26, 2010 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delete project
Replies: 3
Views: 1859

Thanks Ray,

I don't see full description.

please place a command for delete project through command line.

Thanks
by smithasri
Tue Jan 26, 2010 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delete project
Replies: 3
Views: 1859

Delete project

one of my DSAdmin deleted project at OS level. So I need to delete project DS admin drop down box, Please let me what is the TCL command or unix command to delete project
by smithasri
Mon Dec 14, 2009 8:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read more than 4000 bytes from clob
Replies: 5
Views: 2158

chulet,

I am getting the same error. Please help on this.
by smithasri
Mon Dec 14, 2009 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read more than 4000 bytes from clob
Replies: 5
Views: 2158

Thanks chulett

I tried that option, But no luck.
by smithasri
Mon Dec 14, 2009 4:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read more than 4000 bytes from clob
Replies: 5
Views: 2158

Read more than 4000 bytes from clob

Friends, I am reading data from CLOB column from table(oracle 10G) trhough ORACLE EE stage. It was working upto 4000 bytes from this sql (select dbms_lob.substr( TEXT1,4000, 1 ) as TEXT1 from WCCETL2.TEST1). but in my clob column have more than 50k byte. above sql is not working for that. Please hel...
by smithasri
Tue Dec 08, 2009 9:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column BATCH_ID floating point decimal is not fully supporte
Replies: 5
Views: 4561

Thanks Chulett

I tried this way and other possible ways also .Still i am getting same warning message.

I am thinking do we need any patch for this warning?

Thanks
by smithasri
Tue Dec 08, 2009 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column BATCH_ID floating point decimal is not fully supporte
Replies: 5
Views: 4561

Column BATCH_ID floating point decimal is not fully supporte

Hi Friends, Actaully in my oracle 10 g database batch_id clumn datatype is integer, when i importe metadata through orchestrate schema define, I am getting decimal(38,0) in metadata. But I am getting the waring in DS8 "Column BATCH_ID floating point decimal is not fully supported; adjusting the...
by smithasri
Thu Nov 12, 2009 12:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Plgu in Config
Replies: 7
Views: 2713

Arndw, I am getting the following error, main_program: Fatal Error: Fatal: Shared library (mqs.so) failed to load: errno = (2), system message = (Could not load module /home/app/is/opt/IBM/InformationServer/Server/DSComponents/bin/mqs.so. Dependent module libimqb23ia_r.a(libimqb23ia_r.o) could not b...
by smithasri
Thu Nov 12, 2009 11:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Plgu in Config
Replies: 7
Views: 2713

Thanks Andy for Info,

But i am bit confusion, how do we communicate the Datastge server to MQ server if no config was required
by smithasri
Thu Nov 12, 2009 11:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Plgu in Config
Replies: 7
Views: 2713

Thanks Andy,
I have all info. But how to configure on Datastage server. Please provide all required info for admin.
by smithasri
Thu Nov 12, 2009 10:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Plgu in Config
Replies: 7
Views: 2713

MQ Plgu in Config

Hi Every one,

In my company useing MQ Plugin. But Admin does not have any Idea How to config it on datastage.

Please provide all required info for MQ Plug in config on datastage server.

Thank you very much for every one.