DSXchange

Connections to "UniVerse" are unaffected by the Data Direct driver issue. That's because, while such connections use ODBC protocol, they do not actually use a driver. Therefore the answer to Craig's question is "No Worries!".

A StopJob request sends a signal. The recipient process requires CPU cycles to process that signal. A sleeping process does not consume any CPU cycles; it is only scheduled back onto the CPU when the sleep semaphore times out.

Please post HOW this topic was resolved.

Can't comment on "remember me" because I don't use that feature.

But I have noticed recently that IE6 gets logged out if I follow a link using Open in New Window - even if that link is to another post on DSXchange!

And, of course, that wipes out the "unread posts" icons.

Look at the score (set APT_DUMP_SCORE to True). Is DataStage inserting tsort operators or buffer operators?

Look at the score (set APT_DUMP_SCORE to True). Is DataStage inserting tsort operators or buffer operators?

Welcome aboard. :D

1> Yes and yes
2> Yes
3> No - must be one by one

Alas, there's no ODBC stage in mainframe jobs.

I_Server_Whale wrote:The Trim() is necessary, otherwise the number '1' is appended to the result.

This number '1' is from:

Code: Select all

1 records listed

You can lose that by putting COUNT.SUP into the query.

That's not my code, so you didn't "figure it out". You don't need the loop if you use ReadList and Convert. And you don't need Trim either. There is no extraneous space in the Select List and therefore none in the dynamic array and therefore none in the comma-delimited list. There's no column headin...

"Data source name not found " is fairly self-explanatory.

Start by importing the table defintions from the ODBC data source. This will automatically populate the uvodbc.config file in your project from the DSNs defined in the Windows registry.

I'd rather expect that Col4 would be Char(6) - string[6] in record schema terminology.

From the Dictionary of Computer Terms

Recursion [n]: see Recursion


You are going to have to create something - whether a job sequence, a routine, whatever - to process this Data Set over and over until there are no more child links.

Using a Select List will obviate the generation of linefeeds. FUNCTION GetJobNumbers(IgnoreMe) * Generate Select List 9 of job numbers Cmd = "SELECT JOBNO TO SLIST 9 FROM DS_JOBS WHERE NAME NOT LIKE '\\%';" Perform Cmd * Convert Select List 9 into dynamic array then to delimited li...

To reinforce what Craig posted, ISO 8601 specifies this year-first format precisely because timestamps thus constructed can be directly compared as strings. Depending on where you are getting your data from, you should be able to specify the format as part of the extraction SQL. If it's a text file,...

Hasn't this question been asked recently? Has it become a standard interview question?