DSXchange

INDEX() to get the location of "SSP." then substringing to extract the particular characters you need. Try it yourself; come back if you're having difficulties.

A simple test to see whether there are any non-printing characters is OCONV(TheString,"MCP"). This converts any non-printing character to a period. Note that " " (space) is a printing character. You can also use a hex editor on your output file to see exactly what the non-printing character is. If y...

chulett wrote:

ray.wurlod wrote:There's no way a tied socket can remain so through a UNIX re-boot!

Guess you've never worked on a Tru64 cluster, eh?

The OP is on Solaris, so I based my reply on this knowledge.

This is a strange error message in that RT_CONFIG1344 is not executable; it's a configuration file that describes an executable job! Maybe that's another area where the terminology could stand a little more clarity! That it can't be opened usually means that it's been removed, that its permissions h...

When you say "rebooted the server" do you mean "DataStage services" or the UNIX machine itself? There's no way a tied socket can remain so through a UNIX re-boot! Did you try starting the dsrcd daemon in debug mode after the re-boot? If so, what messages were in the log this time? Have you read this...

Why? The DataStage job itself can do this. Create another link from your Transformer stage, containing columns to match the stage variables you want to send elsewhere. Run that link into an Aggregator stage, group by everything you need, and set the set function (on a dummy column) to "Last". The ou...

From memory it can either use FTP or RFC. Check the manual.

mhester wrote:Here are some references that may help you in your research regarding encryption/decryption algorithm's and methodologies.

Aaaaarrrrggghhh!! The apostrophe's again!!!

Ascential Software have advised (on the Oliver list) that they now have "3 very experienced trainers on the ground in India". :D Contact Peter Zeglis (Peter.Zeglis@AscentialSoftware.com), who is fairly newly appointed to head up the Professional Services and Learning Services organisation in Asia Pa...

Metadata for the Repository tables is deliberately withheld. Even if you do create F or Q pointers, most of the run-time tables have only the primary key defined. The design-time tables have standard metadata defined (only four or five non-key columns), probably none of the detail you're seeking. An...

Use two Transformers.
Generate the numbers in the first, and pass this as one column along the link to the second.
Do the lookups in the second, the original number is available on the input link for use in any stage variable, output link constraint or column derivation.

Thanks for the feedback.
The Debugger does have the tendency to make sure all variables are assigned, so that it can do what it does. The process of preparing them for potential inclusion on a watchlist has this effect.

Once upon a time UniVerse and UniData were competing database products (the former made by a public company called VMARK Software, the latter by a private company called UniData). DataStage was originally developed as a UniVerse application. Meanwhile UniData had acquired PRISM (of PRISM Warehouse E...

UniData is a database product, similar (to the user) to UniVerse. Both are now in the IBM stable. The UniData stage is used to connect to the UniData database, much in the same way as the Oracle stage types are used to connect to the Oracle database, or the DB2 stage types are used to connect to DB2...

Whenever I've needed to achieve something like this I've done it in DataStage BASIC code, usually within job control. It's quite easy to check for the existence of one or more files, particularly since DataStage has the inherent ability to treat a directory (folder, for WinNT folks) as a "table" in ...