DSXchange

I have datastage job using ODBC Enterprise stage to load data into SQL server 2005. This job has been running fine for one year with no issues. But now This job got failed due to the errors below. These error messages are taken from log. APT_CombinedOperatorController(1),0: [DataDirect][ODBC SQL Ser...

Do we have something provided in datastage to read hl7 kind of files(msgs).

Thanks,
Hari.

I have one datastage job which creates date value and stores it in a file. I need to read this value and pass as parameter to second job.

Thanks,
Hari.

You have two db2 stages as inputs to your funnel stage correct me If I am wrong. The error could be because of it (funnel) did not receive the data from one of the two sources. Next time when you get the same issue, try to look at the query statement of both of them. One of them might be causing iss...

Hi Amit,

Can you give more info about your jobs and sequence that helps us to think of it.

Thanks.

What stages are you using to accomplish your task. We can guide you If you give us info on it.

Thanks.

Thanks Bandish. Database Oracle 9i and Datatype of Timestamp column TIMESTAMP(6). Do we need to have patch for this versionm too. Pls. let me know if it is required for 9i too. [quote="bandish"]Is your Database Oracle "10g" and Datatype of Timestamp column TIMESTAMP(6)? Then you ...

Thanks Ray. I am able to import the metadata using orch schema definition for all the oracle tables except tables have timestamp column. Let me know if there is any special handling. Thanks. [quote="ray.wurlod"]:idea: Whenever you see "internal error" you need to involve your sup...

Abhi, I do have table created already. Here is my table staructure used to create table. CREATE TABLE PS_G_GC_RU_2AW_STG ( EMPLID VARCHAR2(33 BYTE) NOT NULL, G_GC_RSU_DATE TIMESTAMP, G_GC_CURR_CODE VARCHAR2(6 BYTE) NOT NULL, G_GC_CASH_LOC NUMBER(19,4) NOT NULL, G_GC_CASH_US NUMBER(19,4) NOT NULL, G_...

Hi, I am trying to import the metadata from oracle using orch schema definition from ds manager. But I got the following error messages. Can anyone help me out with this. ** Error executing command: orchdbutil show GMCC.EX -dbtype oracle -server DEVOTD -dboptions ********* ##I TFCN 000001 13:12:04(0...