DSXchange

Hi Forum I create a job that evaluate a flat file, when existing wrong records will reject a file. This job is called from a job sequencer using JobActivity stage, after this stage i use an ExecuteCommand stage, in this stage i execute the follow command: wc -l /dat/CLIENTES2.REJ | awk '{print $1}' ...

Hi cnu

In this case you must type the full that appear in the tnsnames.ora, for example

my.database.ora.com
{
etc
etc
}

when you define the property: Remote Server = my.database.ora.com

I hope this help

hi keshav, in my job i dont insert in the oracle yet, i was insert in a dataset and checking the value, the problem was with the display column, the sparse was working ok, the visualization it was the problem. so, i dont need key to execute this query, because the lookup execute the query and return...

hi keshav0307, i change my oracle query with : select Orchastrate.correlativo as correlativo, sq_user.nextval as sequence from dual but, when i run the job, fail, and show this error in the log: LOOK_001: GenericQuery:esqlErrorHandler Prepare failed for: GenericStmt_1 query is: select Orchastrate.co...

I change to sequential, but obtain the same result.

The sql query is select 1 as ind, seq.nextvl from dual;

I use the ind = 1, to match with the lookup records.

Hi chulett, This is an example of the result: ODBC records Code Name Ind --------------------- A100 Jorge 1 A200 Miguel 1 A300 Luis 1 A400 Luis 1 A500 Luis 1 A600 Luis 1 A700 Luis 1 Oracle Sequencer .nextval = 5 Result (after lookup) Code Name Ind nextVal ------------------------------- A100 Jorge 1...

Hi Forum, Im using lookup to use an oracle sequencer to obtain a generate number, odbc stage ------> lookup ----> odbc fields + oracle nextval oracle stage ----> stage The problem is when the retrieve the nextval this is the same value por a group of records, 5 records or 10 records, is different fr...

Hi, actually i working with DS EE 7.5.2, and i created many projects in the server. now, in one project are working my Teradata project but, there are problem to work in this project 1) The job duplicate for jobname, in the manager i see two jobs at sametime, when i double click appear all informati...

Hi Leeb, I hope this help you ... when i install the DS enterprise in this case, will run in AIX server. the instalation crash in the N step (i dont remember what step), the problem, the CD files was copied into the server. When we run from the pishical cd rom mounted in the server, the instalation ...

Hi, I have a job that read a sequential file and i set Reject Mode = Output, the records are writing with varBinary datatype in the reject file, when i try to read the data has this format (in the file from UNIX): 0092251001431037000004310370000000111 in the view window: {0 0 9 2 2 5 1 0 0 1 4 3 1 0...

Thanks for your answer, but there is a problem, the table has 187 columns and defined in a DDL using the Create Statement is heavy, is there any property to define this only????

Thanks

Hi Forum, :) I'm working with DS EE 7.5.2 on AIX, my jobs need to create the target table, but i dont found any property in the help and the stage to set the Tablespace Name. The DBA create an special tablespace for my jobs, and i want to redirected to this tablespace to create this, and dont use th...

Hi Forum, I installed the pack for Oracle Applications in my DS server 7.5.2, and i need to execute the concurrents scripts defined inside the oracle applications. I want to know if it's doable call concurrent programs (launched from the Oracle Applications GUI) from DataStage using the pack for Ora...

Hi Forum, :) I'm migrating DTS processes to DataStage jobs, but, in this DTS the customer use code to insert record in a log table, this log table contains all sql operations including the number of records affected, for example, after an insert, delete or update sentence. In sql server, this is pos...

Ray, I'd configure my UniData conection in the uvodbc.config with this values <UDUni> DBMSTYPE = UNIDATA network = TCP/IP username = p1002 service = udserver host = 100.128.11.4 account = /tell/data/C3Dic/customer When i try to import metadata using the Manager show me this message SQLExecDirect: Fa...