DSXchange

Hello? Is there someone there?

Hmmm... could have sworn I heard something...

Can you find out whether our current PeopleSoft EPM 9.0 supports the new datastage version 8.1? No, but you can. That would be a question for whomever is providing the proposal to you, that or your official support provider. Also, let me know whether the cutom jobs based on the datastage version an...

No clue but it really shouldn't be called that way. Try changing your call to reflect this syntax and see if it changes the behaviour you are seeing:

And then once you figure out what the 'first' record should be, either constrain your query to its primary key value or perhaps use "and rownum = 1" to help there.

:shock: Yikes... no-one there has ever worked with XML, period? Forget about the "with DataStage" part, no experience whatsoever? That's going to make what you need to do pretty darn difficult. And there's no "urgent" here, just volunteers like me posting when and if they can... ...

That makes more sense if you need to check that all 12 significant digits are 'used', so to speak. Again, assuming this is coming in as a string, there's also a game you can play with the Convert() function - strip out all valid values and if the original value was valid nothing should be left. Left...

Seeing as how we have no idea what you mean by "read" in this context or even "via UNIX", that makes this impossible to answer. Can you clarify please? Perhaps throw in an example or two? Are you trying to script something?

An integer is an integer so a check to ensure there are 'enough leading zeroes' doesn't really make much sense as they don't have them. Or is this coming in as a string? I would guess so based on your other criteria. :? Look into the IsValid() and Length() functions... the latter could be Len(), don...

The dtd isn't strictly needed but may be able to provide the metadata you'd want for the XML you need to process. Import the metadata from the dtd (if the importer supports that, don't recall) either that or from the xml directly or possibly use the dtd to build an xsd with a tool like XMLSpy, perha...

Or that.

Set the "Upsert Mode" to Insert Only.

That would be "upsert"... "upset" is something else entirely.

Why not use a Lookup stage, only send records to the stage that don't already exist and then just insert?

Strip out the delimiters, convert() comes to mind.

It's compressed and istool will automatically uncompress it for an import. From what I understand, you should be able to manually uncompress it as well using standard tools.

Thanks Ernie. It's been way too long since my RTI days, so didn't remember all the fiddly bits of exactly where to go, let alone where / what everything is now in the WISD world. And being a studly Informatica dude nowadays, no way to check either.