DSXchange

Hi,

What is the meaning of the warning message -

not supported for pre-defined update action.


Thks

Ketfos

Hi, I am using ORacle 9i with user defined sql and use following to transform the date field in my sql statement. insert into datefield values TO_timestamp(:7, 'YYYY-MM-DD HH24:MI:SS:FF'), I get following warning message follwoed by error message Stagenametest is not supported for pre-defined update...

Hi,

I have source and target Oracle tables. Both tables have field DeleteTime as datatype Timestamp(6).

How do I populate the target table so that I get the complete date as timestamp(6) i.e 2003-03-26-2.48.07.270954

Thks

Ketfos

Hi,

1. What entry/text/command I need to put in dsenv file for intializing Db2 plugin?


Ketfos

Hi,
Do I manually need to make some changes in the file after I install plugins?

Ketfos

Hi,
Last month we brought the server down.
Installed DB2 and Oracle9i plugins. and brought server up
We were able to use Oracle9i plugin without any issue.

This morning I tried Db2 plugin and came across this problem of intializing

Ketfos

Hi,
Db2 plugin was installed after a year of datastage initial installation.

Ketfos

Hi, I am using DB2 plugin DB2_UDB_API_5 in datastage 7.5 When I try to import table definition using Plugin Meta Data Definitions and select IBM Db2 data Access Plugin from the screen and click ok, it gives error message " Unable to Intialize plugin" Can you suggest what step I am missing?...

Hi, I am using Oracle9i and datstage 7.5 I want to read a table . The structure is like COMPANY_NAME VARCHAR2(100 BYTE), VISIT_DATE DATE, REPORT SYS.XMLTYPE When I try to read in datastage, I get Unknown Column type for SYS.XMLTYPE. This happens when I try to load the column definition for this tabl...

Hi,
The display is set to 26.
When I view in datastage it is trucnated as
2000-08-31 20:49:03

WhenI query the table, it shows full 26 char as
2000-08-31-20.49.03.932430

Thks

Ketfos

Hi, Thanks everybody for help. I was able to insert the timestamp datatype in the target table using user defined sql suggested in the earlier posts correctly. INSERT INTO TEMP_table(POSTING_DTS) VALUES (TO_timestamp(:1, 'YYYY-MM-DD HH24:MI:SS:FF')) I can view the data in the target table correctly ...

Hi, I am using DataStage 7.5 Server Edition with Oracle 9i. I have source table A, column PostingDate defined as timestamp(6) e.g 2000-08-31-20.49.03.932430 I ahve target table B, column PostingDate1 defined as timestamp(6) When I look in the target stage, I have defined it as column generated SQL a...

Hi, As metioned in the last post, you should use Unix dsjob command You cna write a small shell script which will invoke UNix dsjob command. Pass the parameter like -report to this command. Capture the out of the dsjob comand to a file. Use grep command to search for lines with status code <> 0. To ...

Hi,
Did you try moving data from Unidata to a sequential file?

Ketfos

Hi, I am trying to transfer image from Oracle table (datatype BLOB) to a file. How do I read the BLOB datatype in input Oracle Source Table. When I run the job, it aborts giving error message ORA 00932 - Inconsistent datatype. What datatype should be associated for BLOB? I checked up few posts and t...