DSXchange

1)With the option checked as Fixed width columns in Input Tab Which length is given preference? Either Display or length column in columns tab? The Display is used for determining the column width 2)What is the Load option in format tab meant for? The Load is used to load in a metadata column descr...

No problem - I wouldn't have found it unless I actually used it, either.

Palmeal - the DSGetJobInfo also has a DSJ.JOBLASTTIMESTAMP for the finish time of the last run.

Palmeal,

Isn't using the DSGetJobInfo function with the mnemonic key DSJ.JOBSTARTTIMESTAMP easier and more direct than looking into the log files?

december786, if you want a 1-liner you could use IF(ICONV(InLink.TheDate, "DYMD")=InLink.TheDate)THEN 'Bad Date' ELSE 'Good Date' This is because an unsuccessful ICONV/OCONV returns the original string. It is much better to use a short routine and get the value of STATUS() ...

The Transaction Size is the number of rows between database commits. If this is 0 then a commit is done only at the end of a run; this is the quickest choice. Unfortunately, the downside is that with large numbers of records you can or will overflow the rollback space within the database. The size o...

Ray - you mean client-side, right?

Ummm.. I was wrong, we are using it; and it doesn't (have a commit row interval)

Well, you need to see what the routine DateGenericIsDate() does; I don't know what sort of date it expects as an input, but the ICONV() function I gave you returns an integer internal date - which is what you asked for.

You can perform a ICONV(In.DateString[1,4]:'-':In.DateString[5,2]:'-':In.DateString[7,2],'D4-ymd') to do this.

Pandu, (a) When you test it with 2 different files and both jobs have errors you get the data subsets written correctly to both files? (b) You checked in your master sequence that all calls are sequential and not concurrent (I still am sure that this is where you are getting your problem)? (c) You a...

wiant,

unfortunately you cannot export a project from the "dsjob" command on the server; in fact the export cannot be run on the server but only on the client. You can, from your client machine, issue the dsexport.exe command.

If you change the name of the 2nd output file and run your test with both writing, does that work as expected? I should also have been more explicit in my first response, on the first call from the sequence, in the "triggers" tag do you have the output marked as "conditional"?

I'll be darned if I can find that property for the Oracle OCI stage in Px, though.

Pandu80, the "overwrite" and the "append" switches work for sequential files, so my first assumption would be that in your sequence you are not ensuring that Job 2 starts after Job 1 finishes; i.e. they are running at the same time. This would give a concurrency issue where your file contents are th...