DSXchange

Hell if I know, me no do SAP. A dataset you've created from SAP data?

I was going to offer that up as well, but they are 'reading data from tables' so... ??

D'oh! '032' would be the decimal equivalent and what the stage needs, first thing I always think of is a hex 20 for a space.

Wasn't gonna touch that, Ken.

Welcome. If the fields are delimited then it is not a 'fixed width' file. What happens when you specify the delimiter as a space? You can use '020' instead, if you like, to make it more obvious.

You might also want to explain what you mean by 'no proper structure'.

Reread my post. Pay more attention to the initial stage, which is not a sequential file stage.

True, you need the single quotes around the job parameter. Missed that. But no, your date mask is still wrong, it needs to match whatever your job parameter looks like.

lstsaur wrote:Develop a server job, Seq_01--->Xml_Input_02--->Seq_03, to learn how to use XML stage. It's much easier.

That should actually be:

Folder_01--->Xml_Input_02--->Seq_03

With perhaps a transformer in there as well.

Umm... typo?

A DATE isn't stored in any kind of external format, so your assertion regarding HLD_INSERT_DT is wrong. And the mask you use in a TO_DATE function should match what you have not what you think you want.


Would be more appropriate.

Not much, other than to point out the Usage Analysis tool for your metadata available from the Manager. It may help.

Some colleagues are suggesting that this would blow tablespace in Oracle That totally depends on your sql / explain plan, how Oracle decides to implement the table join. Drive from the small table and use nested loops against the larger and you should be fine. If you need to use hints to help it ou...

Equivalents of those same functions exist as part of 'dsjob' so you could do the same from the command line. And the 'log file' is a hashed file, not part of the 'UV database'.