DSXchange

Then please mark the topic as Resolved.

ps. You don't need the quotes around FOOTER_FILE. Don't hurt but they aren't needed. And the "-i" means "ignore case", something I wouldn't do in this case.

Won't work as the Pivot stage does 'Columns to Rows'. I'd use a hashed file here, keyed by Name where you read and write to it in the same transformer. The first 'miss' gets the whole record written out with two of the three fields set to zero. Each 'hit' after that updates whatever month you are pr...

Welcome! :D What I would suggest is, rather than use the Nested Condition stage, let proper triggers do all the work. Have an 'OK' trigger from each job that goes to the next Job Activity in the flow. Have an 'Otherwise' trigger (to catch everything but OK) from every job go to a single Sequencer se...

Import the job. First thing it does is 'clear' (delete) the existing job and then it is created with a new job number.

A job has a unique number regardless of if it runs successfully or not, which can change over the lifetime of the job. You can query DS_JOB for the number but I'm curious why you specified 'when it runs successfully'?

One of my job is failing during compilation with a wierd message. Important point to note is, this this job fails compilation intermittantly. Please explain what this means. It almost sounds like you are saying that you can keep clicking compile until it finally compiles correctly. Line 5460 : Erro...

Is that a question? If so, then, yes. Sure. You can choose any value you like to represent null that wouldn't otherwise appear in your data as long as you handle it consistently on both 'sides'. I've done that with '*' or '~' from what I recall.

Make sure you annotate this on the canvas.

Of course.

Is this in an attempt to ensure a file, which is being transferred to your system via ftp, is complete?

Me, I'd grep for the footer record and count the result:


0 = not there, 1 = there. Easy to make a decision from there.

I'm sure there are many to pick from. The only one I know of off the top of my head is the one we use. It is called svalidate and is an XMLBeans tool from Apache. It is command line streaming (hence the 's') validation so can handle (as far as I know) pretty darn big files. Or at least it has handle...

Is that a PX restriction? I use that macro in Oracle table names, file names, hashed file names, etc over on the Server side.

Well... you really still need to take a close look at your XML around the "ABS" value to see what is actually there (if anything) besides those visible characters. A 'linefeed' was just a guess, if you've tried that and there was no change to the output, that suggests that you may not have implement...

Don't specify a $ (or slash) on the left hand side. And where are you passing anything as parameters to the job? There's no -param included with dsjob in your example. $PROJDEF should already be set and isn't anything needing to be 'passed'. And lastly, are the blank ones being 'unset' or just somet...

What? $PROJDEF is 'job only' but $UNSET and $ENV are perfectly valid for use in the Administrator. I thought I should take a minute and clarify this. I've used both of the tokens noted above in the following circumstances: $UNSET An environment variable exists that one does not want set when their ...

Please post questions in the correct forum. This one is for reporting problems with or making suggestions re: the site itself or specific forums here.