DSXchange

Mismatch between the numered parameter markers in the sql and the columns defined in the stage.

You're correct Roy in that there are previous conversations on this topic out there - I should know, I started one some months ago. Also note that databases may have this ability built in. For example, Oracle has the DBMS_OBFUSCATION package that you can call to 'encrypt' things. So, if your data is...

What kind of encryption? Do you have any idea or did someone just tell you to 'encrypt it'? Yes, as noted, it is possible in DataStage if you code it yourself. The level of effort involved is directly propotional to the kind of encryption is being done. Yes, you could also leverage your operating s...

Or 'change'... more than one way to skin the cat.

Check the EReplace or Convert functions in your 'online' help.

You'll need to roll your own as there is no 'encryption' built in. Also note that not all encryption is 'decryptable', sometimes that's a one way street you walk down.

You might want to specify what kind of encryption you need to do.

It ships free with the product, but is a separate install. There is built in help and a .pdf for it was well.

Ok, when 'stuff' goes into the XML Input stage but no 'stuff' comes out, that is typically a problem with your XPath expressions in the stage. That is what drives the parsing of the XMl files. Best way to get that right is to import the metadata of the file(s) you are trying to process, either direc...

Ok, wasn't easy to tell as the latest questions are about '*.txt' files not xml files. So, are these really XML files or text files?

Verify you are only using one field in the Folder stage. Expand on what 'we are not able to get the content' means.

Hi-jacking other people's threads is frowned upon, especially for non-related topics. Both being about 'XML' doesn't count.

Please start your own post on this topic and include all the relevant details - job type, O/S, version, etc.

No idea... perhaps you should post over in the PX or Server forums. I'd also suggest you include a wee bit more detail when you post over there.

Oh, I see you already did. Still need those pesky details.

Actually, there *is* more to it than just that, as it is not a 'normal' project. If all you do is an export, you won't have a working VC project when you reimport. You need to make sure you also backup the special hashed files inside the project that make it a Version Control project - and they all...

Have you configured the DataStage Server for Oracle yet? The process is documented in both the 'Plug-in Installation and Configuration Guide' and the OCI stage docs themselves. Is this your only problem? Are you able to do other Oracle tasks like import plug-in metadata using an OCI stage or run a j...

Don't let the Folder stage bring in huge files in the second field. Only use the first 'Filename' field in the Folder (delete the second) and then switch the XML Input stage to use the Column content option of URL/File path on the Input tab. That should allow pretty much any size XML file to be read.

Or write a script that runs 'after job' to add that date/timestamp to the filename.