DSXchange

chulett wrote:[sigh]

With timestamp you also need to concatenate "00:00:00".

I think you need the date to be in YYYY-MM-DD format. Try this in.Col[5,4]:"-":in.Col[1,2]:"-":in.Col[3,2] Also, what is the data type and length of the date field in Oracle? Is it 38? Do you require time part as well? In other words, is it really a date field or timestamp field.

Just specify that field as Date. You will notice in the "Generated SQL" that OCI stage puts a TO_DATE() function to convert the string to date.

Other 7.x versions on windows will allow you to develop jobs but not compile them. As noted, only 7.5x2 will let you do that on a windoze box.

Search for ftp scripts on google or as Craig mentioned, any tool that the mainframe guys use to ftp files, I think its NDM, not sure. Get them to push the file whereever you want. Connect Direct is another tool used for fast and secure ftps. Also while doing the ftp, monitor the network to find out ...

You have to provide the rowcount initially as a parameter to the job.
Pavan- The method you advised will create a sequential number. The OP is interested in random numbers.
May I ask why you need random numbers?

Its DSExecute() and not DSEXECUTE().

Replace DOS with NT.

While running, check the button "Abort job after" with warning limit to 1. From command line you would pass dsjob -run -warn 1

How are you currently renaming the file? Just pass that command in DSExecute() in a routine and check the ReturnCode and pass it back.

It will not be. Because your only handling successful runs inside the trigger expresions. Anything other then that, is handle by checking "Automatically handle failures", which you did. Hence it handled the situation. Now when you re-run it, the job that aborted will be reset and then run. If you wa...

Write a routine that tries to rename the file. If the file is not there (rename was unsuccessful) and returns a non zero return code. If its there, it returns 0 as return code. Call this routine in routine activity in a sequence job and check for its return code. If 0, run the job else send out emai...

You sure your not appending to a file while doing exports. Either you or your production guy.

I missed the "Random numbers" point in your post. What are you trying to achieve exactly?