DSXchange

Looks like a bug.

Convert the dimensioned array to a dynamic array, which can be returned as a single string. (Read about MATPARSE and MATBUILD statements in the DataStage BASIC manual.) You can access fields in a dynamic array using angle-bracket notation. Your code could have read: str= Arg1 chrArray = ""...

Welcome aboard! :D The message means that there may have been one or more DataStage processes executing when you stopped the server, which have had their shared memory segments removed (and probably died as a result). These could have been connected clients. 99% of the time, restarting forces a cons...

Welcome aboard! :D

Are you using an ODBC stage to connect to SQL Server?
Is it in View Data that these strange permutations of milliseconds are occurring?
What happens if you create a job that selects from SQL Server and writes to a text file? What goes into the text file?

Certainly is. :D

What are you doing with the other 19 elements in the array? Unlike C, DataStage BASIC does not need an array to refer to characters in a string. Can you describe what you want this routine to achieve? It seems, from your code, that you want the leftmost two characters from the string. You can do thi...

What happens if, having connected via telnet and entered the DataStage environment, you execute the following commands:

(Trying to establish why a "can't open UV.ACCOUNT" error occurred.)

If your database allows it, you can do something like: SELECT max(MAXDATE) as MAXDATE FROM ( SELECT Max(DATE1) as MAX1 FROM server1.schema2.TABLE1 UNION SELECT Max(DATE2) as MAX1 FROM server2.schema2.TABLE2 ) The "punctuation" may differ. Otherwise, you can select fro...

Both dssh and uvsh are the DataStage environment on the server machine. DataStage prior to version 6.0 was built on UniVerse (hence uvsh); subsequently it is independent (UniVerse was sold to IBM).

Job1 can trigger a warning, for example by passing a row down a Rejects link. Or it can set a value into its user status area. Job Sequence can detect the job status or user status value, trigger the remaining processing (Job2 and so on) only if job status is OK. Job sequence can also trigger other ...

Irrespective what scheduler you use (AutoSys, SeeBeyond, ControlM, at, cron, to name a few) use the command line interface dsjob to specify what you want DataStage to do. The dsjob command is documented in Server Job Developer's Guide and in Parallel Job Developer's Guide - use the index to find "Co...

Have done so in the past, though DS was running on a Windows-based server. We used stored procedures to generate GUID values (as surrogate keys) and return these to DataStage (as VarChar(36) or VarChar(38) - the latter are quoted). I think I posted example code - it's about two years back.

You need to have been documenting dependencies on the Dependencies tab in jobs and routines. It is this information (AFAIK) that Version Control uses to identify dependencies. However, the Dependencies grid is maintained automatically for job sequences (you should check - this is from memory), so so...

No, but you could write and FTP a text file using DataStage, then remotely execute bcp on the Windows machine.

I've seen the warnings. Recall, also, the threads about licensing and dual core and hyperthreaded chips.