Search found 83 matches

by ririr
Tue Apr 13, 2004 9:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Client Connection Error
Replies: 1
Views: 1337

DS Client Connection Error

I am getting the following error while connecting from DS Windows Client to the DS server on solaris. Failed to connect to host: test1, project: UV (User name and/or password incorrect (80011)) dsrpcd service is running on the server I can successfully connect to the server from telnet client with s...
by ririr
Tue Apr 13, 2004 7:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ERROR during Installation of DS SERVER 7.1 on SOLARIS 2.8
Replies: 5
Views: 2722

Thanks to you all for valuable input. Yes, the files lost "dot" while ftp'ing from windows. I was able to install the s/w. Now, the dsrpcd service is running on the box and during installation i created a project called "TEST". Now that, I am tring to connect to the server from t...
by ririr
Mon Apr 12, 2004 10:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ERROR during Installation of DS SERVER 7.1 on SOLARIS 2.8
Replies: 5
Views: 2722

ERROR during Installation of DS SERVER 7.1 on SOLARIS 2.8

I am getting the following error while installing the DS server(7.1) on Solaris 2.8.

install.sh: /tmp/dsinstall/solaris/server.: cannot open
ERROR: cannot unpack libdslic.so

I checked the file permissions and also for appropriate disk space.

Any help is appreciated

Thanks
by ririr
Tue Apr 06, 2004 7:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert New Rows or Update existing rows
Replies: 4
Views: 1896

What you really want is a slightly different job design. "Insert New Rows or Update Existing Rows" is not efficient for updates; an insert has to be attempted and fail because the row already exists before the update is attempted. A better design is to have two links into the database, on...
by ririr
Mon Apr 05, 2004 2:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert New Rows or Update existing rows
Replies: 4
Views: 1896

Why you do not put a default value (sysdate) in the script of creation of the table on fields "CREATE_DATE COLUMN" ? With each new insertion the fields will be indicated by the date system. You do not need to treat it in your jobs, and it as that it is not updated in the event of update. ...
by ririr
Mon Apr 05, 2004 12:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert New Rows or Update existing rows
Replies: 4
Views: 1896

Insert New Rows or Update existing rows

I am using OCI to perform Insert and Update operations. In my target OCI stage I have selected "Insert New Rows or Update existing rows". It creates the DML's. I want to handle a CREATE_DATE column in the TARGET differently. I do not want to update the CREATE_DATE COLUMN value when the rec...
by ririr
Mon Apr 05, 2004 10:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Return Oracle SQLERROR
Replies: 2
Views: 1429

I appreciate your help!

Thanks
by ririr
Mon Apr 05, 2004 8:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Return Oracle SQLERROR
Replies: 2
Views: 1429

Return Oracle SQLERROR

I am trying to write the errored records to another target table/file. I need to know if I can call the ORACLE's built-in SQLERR exception in my transformer and track the records that failed with the SQLERR and SQLERRM.

Please advise.