Search found 55 matches

by mail2krishna79
Wed Aug 17, 2011 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rejectfiles using sequentialfile
Replies: 2
Views: 2309

Are you asking question or comment?
by mail2krishna79
Fri Aug 12, 2011 9:57 am
Forum: General
Topic: IBM Information Server 8.5 Installation on zlinux
Replies: 3
Views: 2304

Craig,
Yes. Since this is first time I am going to install Information server 8.5 on Unix, I have some doubts.
Please suggest me if you have any set of steps to install
by mail2krishna79
Fri Aug 12, 2011 9:39 am
Forum: General
Topic: IBM Information Server 8.5 Installation on zlinux
Replies: 3
Views: 2304

IBM Information Server 8.5 Installation on zlinux

Hi Experts,
I am try to install IBM Information Server 8.5 Installation on zlinux. Can anyone help me what are the steps that I need to tacke care before install and after installation.

Your inputs are most appreciated.

Thanks
Kris
by mail2krishna79
Thu Jun 16, 2011 2:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQLSTATE=23000, DBMS.CODE=2601
Replies: 3
Views: 6250

Craig,
That is the warning message in Datastage director. I don't have any thing other than that warning message.
by mail2krishna79
Thu Jun 16, 2011 12:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQLSTATE=23000, DBMS.CODE=2601
Replies: 3
Views: 6250

SQLSTATE=23000, DBMS.CODE=2601

Hi, I am getting below warning message. I searched on SQLSTATE=23000 in dsxchange but did not get answer. Can you please tell me what exactly this means? My job design is Hash file ---->TFM---->ODBC Stage tgtins.xfm.DW_Root: DSD.BCIPut call to function SQLExecute failed. SQL statement:INSERT INTO &q...
by mail2krishna79
Tue Jun 07, 2011 9:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning message limit
Replies: 3
Views: 2909

Warning message limit

Hi,
sometimes i am getting warning messages a lot(same warning message).
For example.
APT_CombinedOperatorController(0),0: Null string argument.

Above warning message repeating multiple times.
Is there any technique to limit 2 or 3 warning messages?
by mail2krishna79
Tue May 10, 2011 1:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data stage job running more time.
Replies: 13
Views: 10964

Try recreating the same job because some times internal functions may not work properly while deleting and placing new stages. this might help
by mail2krishna79
Tue May 10, 2011 1:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data stage job running more time.
Replies: 13
Views: 10964

Try recreating the same job because some times internal functions may not work properly while deleting and placing new stages. this might help
by mail2krishna79
Tue Apr 26, 2011 10:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connector Stage Issue
Replies: 3
Views: 5084

If there is a patch, can you guys tell me what is the patch name need to get from IBM?
by mail2krishna79
Tue Apr 26, 2011 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage FIX Pack 1 Patch Installation issue
Replies: 3
Views: 4351

You should have admin rights implement this patch. Please check you have proper rights to install this fix pack
by mail2krishna79
Tue Apr 26, 2011 9:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connector Stage Issue
Replies: 3
Views: 5084

Oracle Connector Stage Issue

Hi, I have a job like this. RowGen---->ORA Connector Stage. Objective of this job is to delete records from the Reject Table. Job previously run successfully but now got a problem. Its keep on running without giving any error message. When i hit Test Connection option in the connector stage getting ...
by mail2krishna79
Tue Apr 19, 2011 1:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Coalesce Function
Replies: 5
Views: 5675

Coalesce Function

I can see Coalesce Function in Oracle 9i, Oracle 10g, Oracle 11g.

Is there any equal function in DataStge 8.1 or 8.5?
by mail2krishna79
Mon Apr 18, 2011 9:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage Variable Question
Replies: 4
Views: 2596

- do both have to be kept for more than one run? Ans : yes. I have a scenario like this. File contains old values as "Customer/details They decide to change that value as "Customer of Details" Over a period of time old value might come or new value might come or both at once. we have ...
by mail2krishna79
Mon Apr 18, 2011 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage Variable Question
Replies: 4
Views: 2596

Stage Variable Question

I have a requireent like this: Old Value : ABCD New Value: ABCDEF we must keep both values. There will be a period of time that we will see both because some records will be in the pipeline. So we need to account for both naming conventions. I created a Stage Variable for this. I did almost coding p...
by mail2krishna79
Sat Apr 16, 2011 9:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Proc did not run
Replies: 1
Views: 1315

Stored Proc did not run

Hi, I have a problem while running stored proc in QA and Prod. Error Message is below: Stored_Procedure,0: Fatal Error: Fatal: ORA-20004: compare merge: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "xxxx" has been invalidated ORA-04065:...