DSXchange

Why not?!! Get back to work IMMEDIATELY!!! If they had wanted you to have a life, they would have issued you with one!

A hashed file (note: it's not "hash file") will never accept NULL as its key value. It will, however, accept "" (a zero length string). Of course, since keys must be unique, there can only be one record with this key value in the hashed file; multiple writes will overwrite. "?" may mean that NLS has...

LOCATE will search at the field OR value OR subvalue level. The syntax required to search at each level is different - you must specify the higher-level element (for example you may wish to search through the values in field #5). Further you may not always want to search from the first element. If y...

rkdatastage wrote:my output is : 1,0022-11-20 04:00:00

So where did that string come from which, you can see, contains the string 22-11-20 04?

Read the entire error message. Does it tell you which stage, which link?

REPLACE is a dynamic array function. You need CONVERT. Something like:

From memory, the PACK also allows you to use a web server log as a data source. That is, you can trace every click on the web server, see what pages folks visited, how long they spent there, and so on, as a source of data for another application, even a DW.

You might be surprised how slick the Aggregator is for counting. You don't use the Column for Calculation method, you simply use Count. It's a very fast transit through the code.

I'd take a punt that what's in the job log (Director) is very likely to be what's sent. Otherwise, your Sybase DBA should be able to monitor the connection and the commands issued thereupon. There may also be trace utilities in Sybase OC - alas this is not an area in which I have expertise enough to...

You seem to have an offset issue - I can see the date in the timestamp. However, you have not provided your entire derivation - for example how does the time component get there? Try doing one piece at a time, to see where the problem is actually occurring. Just Iconv() first, which should yield a s...

Do you have the relevant port numbers blocked with firewall software or similar?

Almost certainly JOB_NAME is the reserved word, then. Change it to something else, maybe THISJOB.

There is currently no book, whether from IBM or elsewhere.

IBM did advertise a class, DX214 (Certification Preparation) but I believe it was only to be offered in consultation with the Information on Demand conference. Nonetheless it remains advertised on their web site.

Does SEQ1 have unique invocation IDs as well?

Read the error message carefully - WHAT job was not in a runnable state - the job or the job sequence?

It makes no difference to this logic whether the job is a server job, a parallel job or a job sequence.

So were they written somewhere else, not written at all, or some other possibility? And how did you prove that?