DSXchange

A table in AS400 has a column named CREATED with datatype Date and it is NOT NULLABLE. I am using the DbVisualizer to view the records. In that most of the records in the CREATED column shows as (null). But I don't understand why, since the CREATED column is NOT NULLABLE. That seems like a question...

What characterset are you working with? Unless it's multi-byte, those two are synonymous.

I'm assuming your "hint" is being used via user-defined (custom) SQL, yes? You may want to have your DBA help you, found this online as a possible issue for it not working: The table hints are ignored if the table is not accessed by the query plan. This may be caused by the optimizer choos...

ICE wrote:I use job parameter to pass NULL value.

Hmmm... you can't. An empty string, perhaps, but not a null.

As noted, you haven't stated what it is you actually need help with nor asked a question. All you've done is state your task. Please try again.

PhilHibbs wrote:

ray.wurlod wrote:Nice work, Phil.

Do you have too much time on your hands?

What I do have is an occasional need to set up several projects within a short timescale, so spending a day now to save half an hour in the future is a worthwhile investment.

reddy1982 wrote:What is the abbrevation for .cks format

Not sure, probably "cks fmt"? However, I suspect that's a typo as I've never heard of it and it's not listed here.

:!: Please don't think that IPC is some kind of magical Silver Bullet such that you can run around and shoot every job with impunity as if you were infested with werewolves. Out of the thousands of Server jobs I've built over the years, probably only a handful actually "needed" IPC. Our go...

Right, the quotes are being stripped so you'll need to escape them in the parameter value. Pretty common DataStage issue, btw.

From what I recall, they are stored in the DSParams file in each Project and any advice regarding them would be platform independant - Windows or UNIX work the same way in that regard.

That's not a "command" of any kind but rather a path and &PH& simply a directory. From UNIX, empty it just like you would any other directory.

What compiler options are enabled? What triggers are you using between activities? Give us a better picture of your Sequence job design.

Yup, that's another option providing you have Server jobs at your disposal. Only reason I mention that is the original post is labelled with a Job Type of "TX".

I sincerely doubt that 7.5x2 is supported by the MCM.

So... any idea what was wrong with the old files?