DSXchange

It's based on UniVerse, which was a proprietary RDBMS owned by the vendor. It's now a proprietary RBDMS owned by someone else (IBM sold UniVerse to Rocket Software in October 2009). However, the version 7 DataStage repository and engine are still IBM intellectual property; this has been the case sin...

You can re-arrange (concatenate) the relevant substrings. You also need logic to add the century number according to your own (century pivot) business rules. A less efficient approach would be to convert the source string into a date then to convert that date back to a string, with a different forma...

How about Len(StringToRaw(InLink.TheString)) ?

Or ByteLen(InLink.TheString) in a BASIC Transformer stage ?

Hence "as far as I am aware". I've learned something today.

To answer the original question, ODBC would seem to be your pathway.

Seems a bit odd to max out at 96TB though - or is this just the base configuration of the E164?

Which database?

(There's no such thing, as far as I am aware, as "HP Neoview database".)

Use /* C-style comments */ in schema files.

However, there is no mechanism for transferring these to DataStage as part of the import process. This would need to be a manual process of transcription.

You should have had umask set to 002 when installing. If not, change permissions appropriately subsequently.

Please provide exact error message.

Without this we are unable to assist further.

Don't be surprised if your system is brought to its knees by 50 simultaneous jobs, unless it's a really heavy duty engine or the jobs are very lightweight. I suspect there is a monitoring and tuning exercise in your near future.

Check the value of your APT_STRING_PADCHAR environment variable.

If you have already opened the file with OpenSeq, then the file size can be tested with the Status statement. This returns a dynamic array of information about the file - from memory, element #6 contains the file size. Status FileInformation From FileVariable Then FileSize = FileInformation<6> End

You can not suppress the generation of log messages. They will always be generated. You can suppress logging of certain messages (but never Fatal ones). There is no great performance benefit in doing so, as the processing to suppress is equivalent (roughly) to the processing to add the log entry. An...

And for the server the answer is also yes, but the 7.x version will need to be an -itag install using a non-default memory key. Version 8.x does not support -itag install and uses only the default memory key (which means also that you can not have two 8.x versions on the same DataStage server machin...

Dates don't have formats - they are binary. So what is your source? If it is a text file, for example, you have a string but, if you have specified a data type of Date, then the import operator will convert this to binary format based on the format string specified in your record schema. The only ti...

What Craig is getting at with his question is that, depending on what character set you are using, it may require more than 40 bytes to store 35 characters. Oracle can be specified to allocate storage in either bytes or characters.