DSXchange

SwathiCh wrote:Oracle funcion:-
(trunc(sysdate,'D') This yields last day of previous week.i.e. sunday

Sorry, but no it does not. It simply returns the current day.

They are 32bit by default and via the GUI. The only way to get one created 64bit is via the command line. Or you can convert an existing one as you noted.

That's good and sounds proper for a Server job so far. More questions - did you import the metadata from the XML itself or from an xsd? Do you have any kind of XML tool there that can validate the file you've been sent, that it is correct and "well formed" because if it's not you'll have n...

I'm not really sure what a "variable length packed decimal field" would mean. Can you provide examples?

Post your syntax.

0x20 is the value for APT_STRING_PADCHAR. i have already tried with all space removing function...but its not resolving. Of course not. You've said these are CHAR fields and based on the 0x20 value you are using, you want them padded with a space so that's exactly what is happening. You can trim th...

I only asked to make sure we're answering the right question, that we know everything that was behind bringing you here. Off the bat, I don't see the connection between them... but maybe that's just me. Requirement is to slpit a file into multiple files based on a fixed number of records ( That is ...

@chullet, in the column tabs i have 42 columns and in the query also i have 42 columns mentioned. I cross checked the query, i have 41 '?' and 1 sequencename.Nextval... So, the query is correct. No, this proves that the query is incorrect and is not set up as I said it must be. You have 42 columns ...

Thanks craig for making correction.... may i have any i/p to solution??? If I had anything to add at the time, I would have done so. Patience. Recently i have removed APT_PAD_CHAR at job level and used on sequence level... then also appering same issue.... Well, it seems your answer lies there. I a...

No, it's UtilityRunJob. DSRunJob is the function that you'd use in a BASIC job control routine and what a Sequence job uses in the code it generates. You could, of course, write something that leveraged that in a similar manner but why bother when UtilityRunJob does all that automagically for you? :...

There is a UtilityRunJob() function that will do that for you. You can search here or in your local documentation for that name to find the syntax, usage examples, etc.

Not positive, but you may need to use a Server job for this... I'm sure someone can confirm/deny.

I only asked to make sure we're answering the right question, that we know everything that was behind bringing you here. Off the bat, I don't see the connection between them... but maybe that's just me.

Right, got that... what about the other piece of information I asked about? Were you able to locate that?

True.

Well... maybe now that people know you're still having the issue, someone will come forward with advice. In the meantime, I'd still open a case and see what they might have to say on the issue.