DSXchange

Yes, I let DS generate the query. The query was generated without a to_char function.
Moretheless, I manage to convert the date using to char, but then it cannot be stored in a timestamp field (or u get the error: ORA-01722: invalid number).
Then bug or not bug ?

Hi ! The job we want to do is the following: 1/ ORAOCI8 to select all the rows from a table, 2/ transformer and calculation of columns of this table, 3/ ORAOCI8 to update the same table. What do we have to take care about for this kind of job ? Will the query be a "select for update" ? Mor...

With DS 5.2.1, in a ORAOCI8 Stage, I have the following error message when I try to do a "view data": DSBrowser..Repository: At row 2, link "DSLink1", while processing column "START_DATE" Attempt to convert String value "16-FEB-03" to Timestamp type unsuccessf...

One " overly:
Oconv(@DATE,"D-MDY[4,2,2]"):" ":Oconv(@TIME,"MTS")
will work.

Oconv(@DATE,"D-MDY[4,2,2]")":" ":Oconv(@TIME,"MTS")
for getting the system date/time when the job started (constant for one run).
Date() Time() function to get the date/time at the moment of the call of the function (changing for the same execution).

Hi all, I have a problem with some of the jobs controls that launches child jobs. The Error Message is: J0CmdSrcCla..JobControl (fatal error from UtilityAbortToLog): USER INFO: CMD/SRC/CLA : Source Clarify Extraction Failed JOB=> J0CmdSrcCla STAGE=> JobControl LINK=> -8 The jobs controls are jobs se...

Hi! Is it possible to determine, apart from by generating an error trying to attach a job whose name includes an invocation ID, whether a job has its "Allow Multiple Instances" property set? Preferably without having to peer under the covers of the DataStage repository. I want to avoid err...

By the way (for ranjan), to insert a parameter value in the name of a file, the syntax is:
FILE_#parameterName#

Thank you for your anwers, to be more precise:
I want to do this in a job server (with a flow design)
and don't want to use a parameter (as this is not a parameter)
...
any other ideas?

How can I insert the system variable @date and @time in the name of a file ? Hope it is possible.
Thanks.

For the help you provide us in the past and for the future,
From Paris and Mumbai, THANK YOU RAY !

I want to make a job sequence abort when one of its activity aborts or finishs with warning.
how can i do this ?
thanks

"I suspect that the variable is not being correctly assigned in the first place."

That's true, I was keeping the Quote characters from the file.
Thanks Ray !

Hi ! I have code created by a job sequencer which I have copy in an other job control to add some code for retrieving parameters for the jobs runned by this job control. I changed my code for DSSetParam like this: err$code = DSSetParam(h$5, ParamName, ParamValue) (where ParamName is the variable whi...

Well I don't know if the problem is when storing the value in the user status area (in the after job subroutine) or in retrieving theis value in the job controler. The point is that from the job controler, after the line: Result = DSGetJobInfo (h$4, DSJ.USERSTATUS) I print the value of Result in the...