DSXchange

Handle what by itself? Using a job parameter for the schema name? Both of these suggestions just go in the 'Table Name' box, no need for user defined sql just for that.

Exactly. Nothing more distressing than rebuilding an index to fix a small problem and suddenly having what looks like a BIG problem - an empty repository.

That's when you really kick everyone out and run it again.

Also consider #SchemaName#Tablename where the value of the schema name includes the dot.

Allows you to pass an empty schema name to optionally take advantage of synonyms or local tables.

You can't just IConv the whole field, once for date and once for time. Break the field up, substring or Field command, and do what you are doing on the two pieces.

And here I was gonna say just lock them - period. One could petition the moderator if something needed to be posted there.

Why come here to a post with two pages of discussion, only read the first post and then bascially say the same thing that's already been discussed in those two pages? What value does that add?

Not sure. The Sequential stage in PX can support bringing in multiple wild-carded files without having to cat them together. However, I don't know if it can supply just the filename of each file rather than the file's data. If that's the case, you can use the URL method in the XML Input stage. Or ro...

Why not do it as a Server job? Does it require a PX implementation?

Operating System is UNIX, I am scheduling my job (for daily run of job) from director. Know that from your post. Was wondering who's it was - HP-UX, AIX, etc. And the other question was to ascertain if you were into 'cron' or 'at' land. It will use cron for recurring schedules like 'every Monday' w...

Odd... what operating system? I assume you are using Director to schedule the job, yes? And 'in future' means what - one time or a recurring number of times?

The 'supplied web browser'? Something other than IE? As far as I know, you need to change it for your PC by adding/changing a NLS_LANG environment variable...

No, it was just the classic problem when people use their own sql instead of letting the stage generate it for them. Column order doesn't match the DML or the number of columns doesn't match the number in the DML or not all values are bound or key fields aren't marked correctly, or... What Arnd mean...

When you say you have 'two environments' does that mean dev and test are two separate projects co-located on the same server? Or are they located on separate servers? And when you say they have 'started generating errors in Testing', I'm assuming they were working previously? If that's the case, the...

Latha1919 wrote:If it is 0, why it is creating the files??

Creating the files happens regardless of the fact of any rows being sent down the link to the stage. When the stage opens the file it is created. If you don't send any rows down the link then what you're left with is an empty file.

Well, then... it would seem obvious that it returned a zero.

Without knowing what in the heck p1, p2 and p3 are or what the routine does with them, don't see how you can expect a better answer than that.