Search found 14 matches

by cipsy
Wed Nov 12, 2014 9:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error with Upsert to Netteza connector IIS-CONN-NZ-01004
Replies: 2
Views: 7897

Hi everybody,

I have same issue. My table have 1 row. but i see same issue. Any idea baout this issue
by cipsy
Thu Dec 06, 2012 6:15 am
Forum: General
Topic: Datastage Client ctrl enter issue
Replies: 4
Views: 2807

Thanks Josh. My client is 8.5 hf1. thanks yoour hepling
by cipsy
Tue Dec 04, 2012 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQLFetch reported: SQLSTATE = 22018: Native Error Code 802
Replies: 5
Views: 12151

This problem is solved. I dont know why reason but we change the sql. I find the a line in table1 (have null value and &) . but sql isnt came this line. example select a.col1,a.col2,a.col3 from table1 a, table2 b where a.id_column = b.id_column a.id_column not joined b.id_column delete it this l...
by cipsy
Tue Dec 04, 2012 3:51 am
Forum: General
Topic: Datastage Client ctrl enter issue
Replies: 4
Views: 2807

Datastage Client ctrl enter issue

Hi,

I'm use DataStage Client 8.5 on Windows 7 Enterprise. And I use toad. I know ctrl + enter combination is very useful on toad. But if Datastage is open this combination is not working. Datastage is closed and ctrl + enter is working.
Why do it? do you have any idea
by cipsy
Tue Nov 27, 2012 3:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQLFetch reported: SQLSTATE = 22018: Native Error Code 802
Replies: 5
Views: 12151

Thanks your answer. :) but job is working alone.
When job scheduled i see this error messages.
by cipsy
Wed Nov 21, 2012 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQLFetch reported: SQLSTATE = 22018: Native Error Code 802
Replies: 5
Views: 12151

SQLFetch reported: SQLSTATE = 22018: Native Error Code 802

Hi, I want read data ODBC source (uses DB2 on AS400) and write to Oracle. Job is simple but job aborted. I see this error messages AS400,0: ODBC function "SQLFetch" reported: SQLSTATE = 22018: Native Error Code = -802: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for ...
by cipsy
Mon Nov 12, 2012 6:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookup Logic
Replies: 4
Views: 3481

I think you can use, user defined sql in source stage.
by cipsy
Thu Nov 08, 2012 5:17 am
Forum: General
Topic: Email Notification Activity
Replies: 5
Views: 3293

All job goes to sequencer stage. And sequencer stage goes Notification activity stage.
by cipsy
Thu Nov 08, 2012 5:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to call db2 procedures with XMETA user
Replies: 3
Views: 4297

Re: Unable to call db2 procedures with XMETA user

Please check owner thats folder

/opt/IBM/db2
/opt/IBM/InformationServer/Repos

Repos folder have xmeta db2 files. if change to owner repos folder your db2 acces to xmeta .
by cipsy
Thu Nov 08, 2012 3:52 am
Forum: General
Topic: Email Notification Activity
Replies: 5
Views: 3293

Re: Email Notification Activity

Hi

You can use Notification Activity and can use job status and job name ( click to ... and see external paramater). But i thinl you cant attached job log.
by cipsy
Mon Aug 13, 2012 6:04 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Unable to Import Web Service Definition
Replies: 1
Views: 4092

Re: Unable to Import Web Service Definition

Copy web page source code a text file and import this text file. And u see web services.
by cipsy
Tue Nov 18, 2008 10:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error 'type mismatch' everytime I paste objects
Replies: 3
Views: 2125

That's my problem. I'm use DataStage on Unix system. Client WindowsXP.

Another client run normaly but some client see this problem. I think Client side problem

Anyone slove please write here.
by cipsy
Mon Nov 05, 2007 6:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The Section Leader on node node1 has terminated unexpectedly
Replies: 6
Views: 9205

Use the Configurations editor to test your configurations file. If that tests out OK, we've eliminated one possible cause of the compilation problem. ... Hi, tool-Configuration-check button. And I'm see this messages. and I'm change hosts file and configuration fast name but my problem not solved. ...
by cipsy
Thu Nov 01, 2007 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The Section Leader on node node1 has terminated unexpectedly
Replies: 6
Views: 9205

The Section Leader on node node1 has terminated unexpectedly

Hi, This is my defult.apt { node "node1" { fastname "EBUSINESS11" pools "" resource disk "C:/IBM/InformationServer/Server/Datasets" {pools ""} resource scratchdisk "C:/IBM/InformationServer/Server/Scratch" {pools ""} } } Click the...