DSXchange

Hi ..
Can multiple instences of a same job write into same DataSet paralelly..?

Thanks in Advance.

I have a set of jobs in job sequencer and now i need the names of the jobs in the sequencer as a comma separated list. What functions can be used for this? Also how can i get the names of individual job activities in a sequencer U right a routine to list all the jobs and call that routine from call...

please provide prerequisite to use MQ Connector

Please provide me prerequisite to use MQ Connector, step wise.

Getting warning The NLS character map <UTF-16> specified may not be compatible with the character set specified by NLS_LANG; you may get unexpected results from your database. ---- My data base setting for NLS is NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS...

chulett wrote:The ODBC stage is the only stage that allows that, AFAIK. ...

but this is strange, because there is no need to update :1 and you are forced to do that

I have query in oracle enterprise stage like UPDATE <Table NAME> SET < Column name> = :2, WHERE <column name > = < Value> :2 is out put of transformer stage which is out put of routine and routine return the jobs fatal errors for given any other job. Getting error ORA-01036: illegal variable name/nu...

chulett wrote:You certainly should be able to do this. Can you explain what exactly you've tried so far? ...

We tried using environment variable to pass dsn, username and password which was not working.

We have resolved this by using job parameters instead of environment.

Thanks for quick reply.

Hi, I am trying to call a oracle stored procedure using a "Stored procedure" stage in a parallel job. When I tried to call procedure by giving the username and password directly, it is working fine. But if I parameterize the username and password and try calling the proc I am getting an er...

Thanks Sam. It works.

But my input data is in the format dd-mm-yyyy. Can I convert a string in the format dd-mm-yyyy to date field.

Hi, I wanted to convert one varchar field into date field using the modify stage. My input field is in the dd-mm-yyyy format and I used the below specification in the modify stage. in_col:date = date_from_string "%dd-%mm-%yyyy"(in_col) But I am getting the below error while running the job...