DSXchange

Welcome aboard.

The specific functionality you ask about is called the Data Browser in DataStage; it's invoked usually by clicking on a View Data button or link.

There is a tutorial that ships with DataStage software; find the tutorial manual in your documentation set and work with that.

This is simply a message to alert you that the reference (dimension) table is empty. That could mean referential integrity problems in an underlying star schema. You could demote the warning to informational for the first load, then remove the warning from the message handler once there's some rows ...

Sequences don't have stages. They have activities. There is no option for the dsjob command for listing the activities in a sequence. However the information should be able to be had from a query against the DS_JOBOBJECTS records for the sequence.

That's not a solution to your original requirement.

That's not how tr works!

Looks like you're after a generic solution rather than a specific one. One approach would be to create DataStage jobs to extract whatever term-related information you have - and only you can know what you have - and write it into a CSV or XML format ready to be consumed by the Business Glossary impo...

... or even "use".

Have you checked with your client whether they want to keep those newline characters? Or is yours a site with no data governance processes whatsoever?

I did not read any requirement to trim characters in the original specification.

If you use an Aggregator stage with Hash as its method, the results are stored in memory in a hash table.

What did happen? (You've marked it as 'workaround'.)

Does the job make any use of persistent Data Sets, File Sets or Lookup File Sets?

Tuning tips for running large numbers of parallel jobs in parallel? Don't.

Not really. ReadBlk is the statement for reading a block of bytes from a file opened with OpenSeq statement. You would also need Seek statements for positioning within the file. All of these statements (and don't forget CloseSeq) are to be found in the DataStage BASIC programming manual.

Your dates don't match the default format string for dates in your project, so you will need to provide a non-default format string in your IsValid() function. The whole of the syntax is to be found in the manuals and the on-line help. Craig only gave the "simplest case" solution, and indi...

Suddenly, eh?

What's changed? ("Nothing" is not the correct answer, obviously.)

Usually this problem is associated with the default WebSphere Application Server process (server1) not running. Have you checked this using the serverStatus.sh script?