DSXchange

PX is very picky about data types and values, so you shouldn't be using a "not null" column definition when you know it will contain nulls. Define it as nullable, then in a transform stage or a modify stage use one of the builtin null handling conversions to explicitly change a null value to somethi...

Andy,

sorry I couldn't help you on this. If you are doing loads, you might switch to the bulk load method and run it outside of DS and capture any errors from inside a script; that is the only workaround I can think of.

-Arnd.

There is no DataStage scheduler, it uses the default Windows scheduler (AT). I don't know why you can't run the DataStage scheduler, unless you haven't installed it on your server. The free UNIX utilities such as mks-toolkit or the Microsoft one (I can't recall the name) have versions of the UNIX cr...

ajit, the message is saying that the column "SOURCE_DT" has a null value in the data, but your target column "DWH_UPD_TIMSTM" does not allow null values and you haven't specified any special conversions for this column; so the job has to abort. You either need to do a right-mouse-click-"edit row" on...

When you test a DataStage routine the engine will put your test arguments into a small program so that the actual function call can tested. Because it assigns the test value into a string it can (and does) get confused with unbalanced quotes. This will not affect your actual runtime values; so you c...

The BASIC routine doesn't care about balanced or unmatched quotes in it's source data string. How are you passing the data to the routine? From the Test run facility in the manager or from a DS job?

Khron, I stand corrected, PHP is a high-level language and has builtin tag handling. Even though having one language support it doesn't really match your statement of "any high-level language" having that capability. I did learn something else from this thread, I had always assumed that the definiti...

Pavan,

I think that Ascential wouldn't have recommended that approach unless they'd found a serious error - as is shown by the admin not being able to login. So your best (and only) option is to restore your backup.

The differences between a new version and it's predecessor are always listed in the DataStage upgrade guide, which is installed in the documentation directory with the name "dsupgde.pdf". The list at 7.5.1a is 8 pages long, so it wouldn't do to paste it here. Bug & performance fixes are a big pa...

The error message you are seeing is most likely an effect of another error. If the process that is doing your writing to the database aborts it will cause it's end of the pipe to be closed and trigger the "broken pipe" error message in the other process. You will need to delve a bit deeper into your...

...It's a pitty that this kind of functions are not included in DataStage, as they are available in any higher level language. Khron, I'm curious - which high-level language has builtin html metatag cleaning functions? The ones that I know for certain don't have ANSII builtin functions are C, C++, ...

Khron, you could write a small DS Basi routine to do this. The following code (untested, written while on-line therefore probably needing debugging) will remove any number of constructs beginning from a '<' and ending with a '>' from a string. Note that it won't work if the string contains a valid '...

Hexa, no, you won't get "any solution" from me - you haven't told us where you are, what your database NLS setting is (and what it is), what your character set is and what language you are working in. So how do you expect to get an answer? The original poster specified both his location and characte...

Hexa,

the language you set depends upon your database and environment - there is no one answer. The most common in the US is "AMERICAN_AMERICA.AL32UTF8 " but that might not be correct for you.

Andy, are you using the reject link functionality with an error link coming out of the DB/2 stage in your job? Also, what is triggering the rejects - just one error code/reason or several? I know I did some jobs that used this type of functionality and would be worried if nothing were reported since...