DSXchange

will pack up any free space in groups and release blocks on the free chain back to the operating system. You do need a pointer in VOC to the hashed file to use RESIZE in this form.

You want to delete ALL sequences from SDKSequences?!!!
Probably not.
Add a WHERE clause to the DELETE.

When any Repository table gets corrupted one of the first likely causes to check is space on the project directory's file system. Even if the disk full condition was transient, you still have a corrupted file, which may or may not be repairable. Search the forum for fixtool. Otherwise clearing the R...

Any format you like - include a TO_DATE() function as part of your WHERE clause, with an appropriate date picture for your chosen format.

In an expression you can not use statements. The conditional expression (IF test THEN value ELSE value) is an expression; it must always return a value and must, therefore, always have both a THEN part and an ELSE part.

The IF statement is only available in Routines.

Certainly did


INVOICE
To: searching forum unnecessarily, $100

Send money for free receipt

The link row counts will be the number of rows sent by DataStage to the database. If any insert or update fails, the row count is not decremented.

Is the input sorted by SBSB as well as partitioned by SBSB?

As far as I can recall, there are some functions explicitly for working with Raw data. Check documentation for Modify stage, and look in the conversion functions in Transformer stage expression editor.

Nice article but please attribute it (tell us where it came from). If you know who Roger Deng is, please post that knowledge also. Without attribution, a cynical reader might suspect that you got the article from MAD Magazine! If the material is copyright there may be other issues, which could lead ...

As far as I can remember, you use either the {} or the CALL syntax, not both, when calling a stored procedure via ODBC. Some drivers/databases only accept one syntax, some accept both.

Welcome aboard. :D This is probably most easily accomplished with a server routine invoked via a Routine activity in a job sequence. FUNCTION GenerateRows(SourceFile, TargetFile) $INCLUDE UNIVERSE.INCLUDE FILEINFO.H DEFFUN OpenTextFile(FileName, OpenMode, WriteMode, Logging) Calling ...

What volume of data is contained in your 1.2 million records? If each were 100 bytes you would have 120 million bytes of data. I suspect that your record size is larger than 100 bytes, on this basis. What do you think is wong with 500MB? Do you really need all the columns that you have loaded into t...

Since it's in the position of an identifier (column name in this case) try double quotes around the parameter reference, making it a "delimited identifier". I'm far from certain that column names can be parameterized in this way. Most solutions rely on making the entire SQL statement a single parame...

Contact the Editor of this site. DSXchange has run some training in SoCal in the fairly recent past, and may be planning to do so again. There's always the vendor (IBM) of course, check their website for training offerings and locations.