DSXchange

Change the metadata to Decimal 38,0 (with an explicit zero)

Search the forum for a server version of IsValid() that I posted a couple of days ago, or write your own specific date validity handler. FUNCTION IsValidDate(TheDate) Test = Iconv(TheDate, "D") ; * default order for this locale Status1 = Status() Test = Iconv(Th...

Must be a huge log if it took over a month to refresh!!!

Glad I could help.

You should never need to "compile" a job automatically, because there is no way that a job can become uncompiled once it has been compiled.

Short Description ----------------- Reports whether test value complies with the rules for a particular data type Long Description ---------------- Returns NULL if either argument is not assigned or if the data type argument is null or unknown. Always returns 1 (true) if the test value argument is n...

Short Description ----------------- Reports whether test value complies with the rules for a particular data type Long Description ---------------- Returns NULL if either argument is not assigned or if the data type argument is null or unknown. Always returns 1 (true) if the test value argument is n...

There is no routine for compiling a job.

No you can't! You can browse the DataStage database.

It's in the database, not in DataStage. Have your DBA explain what it means. Basically the table space in which the table was created has been set up with a certain maximum size, and the table has hit that limit. The DBA can allocated more pages in the table space, but will probably ask you to justi...

We do encourage. What we don't do is supply answers to interview questions, for reasons that have been canvassed more than once (and can be determined via Search). Most of us don't have DataStage software installed on our PCs. It's just too expensive! So we learn by working with - or, initially, bes...

It can't. That's why there are two separate tools.

Change the table definition so that NUMBER is constrained - for example NUMBER(38) - so that DataStage does not interpret it as unlimited (that is, floating point).

UniVerse is a database product, marketed by IBM It is a database product that can compete with the likes of Oracle, Sybase, DB2 and so on. It contains tables, which are implemented using hashed file technology. It also includes a complete application development environment, support for triggers, HT...

What is x..y? Are there two dots between the schema name and the table name? This is not valid syntax.

Checksum() is a BASIC function, so not directly available in parallel jobs. You can access it via a BASIC Transformer stage in a parallel job, with the concomitant overheads of data type translation that this incurs. You could also access it via server job componentry in a server shared container th...