DSXchange

ray.wurlod wrote:You shouldn't need to re-start, but it won't hurt to do so. ...

I restarted but the problem is still here;

helllp

hi - you dont seem to have the orchdb2 operator installed - are u sure db2 was specified when u did the install (I am looking at a v7.5 install so may be different on V8) You also need to watch out as I believe DSV8 can talk to both V8 and V9 of DB2 - however if you dont specifiy db2 version at ins...

I have the same problem: ##F IIS-DSEE-TFPM-00279 23:01:24(003) <DB2_UDB_Enterprise_987,0> Fatal Error: Caught ORCHESTRATE exception in parallel process: APT_Archive::BadClass: From: Loading memory archive: Could not find "APT_DB2ReadOperator". ##E IIS-DSEE-TFPM-00192 23:01:24(003) <node_bd...

I solve the issue by doing this :
Boling[/code]

from root to /opt/appl/Ascential/DataStage/Projects/, I get this right drwxr-xr-x;
So , I think, it is not a probleme of permission;

chulett wrote:Note I did say "to that" not "on that"... you'd need to check all the way up from root. Just trying to cover all the bases.

help please!!!!!

I have "execute" permission to that directory; like this: drwxrwxr-x2432 dsadm dstage 176128 Feb 04 11:06 EIN_TRX_MON_DEV Do you have "execute" permissions to that directory? That is what controls your ability to "cd" to it. I tcheck before asking in this forum; it is o...

This directory exists;
It is my project directory;

I have permission to create, update, etc files in this directory;

chulett wrote:So... does that directory not exist or do you not have permissions to it?

But it difficult to fix this warning;

Hi everyone,

I try to remove the warning below from my job:

DB2_UDB_Enterprise_1,0: Warning: unable to chdir(/opt/appl/Ascential/DataStage/Projects/EIN_TRX_MON_DEV): No such file or directory

Could someone help me to fix it!

Thanks in advance;

Bolingo

The issue is solve by using User insert command like: INSERT INTO TBble (T_ID, T_DATE) VALUES (ORCHESTRATE.T_ID, to_date(ORCHESTRATE.T_DATE, 'yyyy/mm/dd')) In the ODBC enterprise stage, I declare t_date varchar; in open command property I use this query : TRUNCATE TABLE TBble; Thanks all of you for ...

The issue is solve by using User insert command like: INSERT INTO TBble (T_ID, T_DATE) VALUES (ORCHESTRATE.T_ID, to_date(ORCHESTRATE.T_DATE, 'yyyy/mm/dd')) In the ODBC enterprise stage, I declare t_date varchar; in open command property I use this query : TRUNCATE TABLE TBble; Thanks all of you for ...

Why not use the Oracle stage for Oracle then? In other words, why screw with ODBC? What happens if you make your field a varchar in the job and match the NLS_DATE format of the target database? If you don't know what that is, ask your DBA, they'll be able to tell you how it is set. I use ODBC inste...

Date format for ODBC must be YYYY-MM-DD You are using an ODBC driver, and therefore must conform to the standards specified for ODBC. Even if I use this format YYYY-MM-DD, I have the same error: ODBC_Enterprise_102,1: [Oracle][ODBC]Numeric value out of range. ODBC_Enterprise_102,1: Failure during e...

Parallel jobs don't handle this. You could solve it by pre-processing the file (for example using sed or awk command) to convert the double double-quote characters to something else, th ... can anyone please suggest me how do i accomplish this with awk or sed. thanks a lot in advance. Thanks Mark T...

There is no 'date format' in an Oracle database, per se, unless you are attempting to match the NLS_DATE format. Please post the sql and clarify how the DATE column is defined in the job itself. There is not sql query; the main properties of my ODBC enterprise stage are: * target - table=TBablexx -...

if all your 5 fields have the same length in all records; you could process like this: you create a schema file like this: <b> record {record_delim='\r', record_length=fixed, delim=none} ( A:nullable string[4] {width=4}; B:nullable string[1] {width=1}; C:nullable string[6] {width=6}; D:nullable stri...