DSXchange

"J3stat" will never be anything other than RUNNING because that is the job's current status. Why do you check the interim status as requested and then do nothing with it? Check J1stat to decide when to send an email. I've said this before and I'm going to say it again - the job's status will never b...

I just stumbled across a section of the online help for the XML Output stage that says: 'Validation against an XML schema is required when you want default values for elements and attributes that are specified in the schema written to an output row. To reference a schema in your XML document, use th...

Yes you did. Me likey what you done did and fully intend to steal bits of it when I have some spare time. :D

Parameter markers are the question marks in your SQL, bind points waiting for column values to be supplied at runtime. Positional meaning that the position of the ? in the sql is mapped to the position of each column defined in the stage. For example, when it sees 19 of them, it sends the value in ...

You'd probably want to flip the query around for your needs:


And then handle your parameters accordingly based on the type retrieved.

I'm not sure whether the XMLOutput stage will do this for you if the column value is NULL, but I tend to doubt it... this would require further testing, but you should be able to force the attribute yourself... I haven't found a way and this *is* something we actually futzed with at one point. We e...

Not null where? Nullable 'No' in DataStage? Yes. NOT NULL Fields in a database? No, that would defeat their purpose if that was allowed.

Hmmm... for some silly reason I was under the opposite impression.

I thought 'XML' meant the output needed to be 'XML Friendly' and thus would do those conversions. But then, the last time I tried to find out where all those data elements were documented, I failed miserably.

Dollars to doughnuts a text field has a LF - a CHAR(10) - in it as 'data'. UNIX will see that as a record separator.

Easily handled by the hashed file stage. Performance would be best if you've 'pre-sized' it for that volume by bumping up the minimum modulus. Have you done that or is it still at the default of 1? Have you used the HFC / Hashed File Calculator before? It can be found as an 'unsupported utility' on ...

Welcome aboard! :D

Define 'huge' for us, please.

Ok, two things. 1) Check the INTERIM status of the job after job, that will allow you to decide if an email should go out or not. Keep in mind the fact that an Aborted job won't be able to send emails, only one with warnings will. A Sequence job would solve that 'problem'. 2) I know you've mentioned...

Check the INTERIM status of the job. Why not use a Sequence job for this, handle it with the Notification stage and the appropriate triggers?

Um.. no. Never been anywhere with 70 projects. Perhaps there's a way to show the next 'page' of project names? It's been years since I've used the Package Installer so don't recall all the gory details of its usage. Can you just type in the project name or must you pick it from the list? You should ...

Talk to your DBA, they can explain exactly what you are doing wrong that would violate a foreign key constraint like that.