DSXchange

We would like to know whether the -WAIT parameter prevents the job following this job to wait or does it imply that the job which has the -WAIT parameter actually waits for the preceding job. Neither. It means the job you initiate with the -wait option will not return control to the shell script un...

Welcome. You need to convert the date separately from the time. Do you need the time portion or will it be discarded? You use the 'Conv Brothers' - IConv followed by OConv to convert dates. The former takes the current format to an Internal or numeric format while the latter takes that number and bu...

Yup, exactly right.

What happened when you tried to load the data? Note that CLOBs (or really any kind of LOB) are not supported, so don't look for any 'official' mechanism.

No. The file will always be created. If that 'issue' really bothers you, you can check after job and delete any zero-byte file I suppose.

You'd need to pass those values in as job parameters to use them in the filename when created. Another option is to create a static filename and then rename it / add the timestamp after job, typically via a generic script.

Of course parameters can be used in the stage. You'd have to show us your syntax to know what went wrong. Guessing you may not have enclosed the parameter name in hashes / pound signs.

The IConv mask must match the incoming date format. You've used "ICONV("Column_Name","D-MDY")" and shown a date example of "19-SEP-08". See the problem?

Suggest you double-check your user-defined sql. To get any real help, you'd need to post the sql and the error you get when using it. Details, man!

yuva010 wrote:Calling stored procedure in PX, requires to define System DSN on DS server. Does it slows performance heavily?

No. There's no inherent penalty in simply defining a 'system DSN'.

ray.wurlod wrote:If you prefer your website a little more high-tech, this one actually has a live webcam both inside and outside the facility. It's actually pretty interesting to watch

Funny boy.

Not sure on a command line answer for the first question but the second one is 'dslictool' in $DSHOME/bin.

Using or is licensed for?

That's an interesting bit of news. Due to compatability issues with newer drivers accessing older instances, I've always taken a 'least common denominator' type approach when it comes to Oracle connectivity. I use the client software from the oldest instance I need to connect to and don't have any i...

Yup. Been able to do that for as long as I can remember.