DSXchange

Hi Craig That is the sql instructions, you must to believe because it wotks. -------------------------------------------- SQL> INSERT INTO USR_ADMIN.O_CALL_TD_PROBE (FECHA1,FECHA2) VALUES ('test',TO_TIMESTAMP('20090227','YYYY-MM-DD HH24:MI:SS')); 1 row created. SQL> commit; Commit complete. --------...

Hi Craig, I run the sql query, exactly like the generated into oracle stage: INSERT INTO USR_ADMIN.O_CALL_TD_PROBE(FECHA1, FECHA2) VALUES('hola', TO_TIMESTAMP('20090227', 'YYYY-MM-DD HH24:MI:SS')) and insert without problems, the problem is the routine result, because return the value with diferent ...

Hi Forum, I have a problem when insert record into oracle database, My job consist in a oracle source, a transformer, and a oracle target oracle --> transformer --> oracle. the target has 2 field (field1 varchar2, field2 date), when import the metadata that fields appear in the table definition with...

Thanks for your help, i was swimming in the forum and i found the answer for my problem with Oracle, i will share it with you. You must to create two links, for the old version (9.x) and other for the new version (10.2.x) This is the first link: ln -s $ORACLE_HOME/lib/libclntsh.so.10.1 libclntsh.so....

Hi, I'm installing and DS EE 7.5.3 on HP Itanium with OOSS HP-UX 11.31, before the install the oracle client was installed. Now when i tried to view the data using Import-Plugin metadata definition obtain the error message 'Unable to initialize plug-in:' The DS installer is the Itanium version dont ...

Hi vish08

Your command is incorrect, the sintax is:

$ dsjob -run -mode NORMAL -wait -jobstatus -param FromDate='80909'
-param ToDate='80910' ADW_SALES TestSalesDetailFixEE

Try with this correction.


:D

Hi cherry Did you search the error code ??' i did, this is the explanation # oerr ora 00022 00022, 00000, "invalid session ID; access denied" // *Cause: Either the session specified does not exist or the caller // does not have the privilege to access it. // *Action: Specify a valid sessio...

Hi abhishekachrekar,

PLease search in the forum about DS.TOOLS, the job maybe need to unlock by command, once have that problem.

I hope this help.

Hi abhishekachrekar

PLease check this link

viewtopic.php?t=121475&highlight=mmap

in this post appear a similar case, but using sort stage, i think that the solution will work in your case.

Thanks Ray,

I need make a routine to obtain this atribute or there is a function to make this select???

Hi Forum,

I'm using the DSGetJobInfo Function to obtain information from jobs, but this function dont return the job type (server or parallel), this attribute is important for my process because i need analize the job server and parallel for separate.

I expect for your answer.

Hi Raj, thanks for your comments.
The conection was seted in the .odbc.ini, in the pc nothing. I dont need to set an ODBC dns in the pc because the server is running on the unix box.
and the user is the same when connect in the differentes pcs.

Hi Ray,

This pc isn't different from the others workstation. i reboot the pc but the message error continue.

Hi Forum, I was testing a job in my pc and appear this message when try to view data in the ODBC stage: Error executing View Data command: :shock: ##F TDOD 000004 11:28:11(034) <main_program> Fatal Error: Could not connect to datasource[DataDirect][ODBC lib] Data source name not found and no default...

Thanks the job sequencer is working ok.