DSXchange

I'm sure if you Search on DSXchange you will be able to find some examples.

Welcome aboard. The correct forum for this post was "Information Analyzer (formerly Profile Stage)". The suite of ODBC drivers has one for text files. Basically you create a DSN that uses that driver. You will need to make the parent directory one of the properties mentioned in the .odbc.i...

DataStage represents null internally using a single byte with bit pattern 1000000 (or Char(128)). Windows uses this byte to represent the Euro symbol. I believe there's a way to change the DataStage internal representation, but can't recall what it is (and am not currently working on a Windows serve...

Were you intending this to be a topic for an FAQ?

If not, please re-post in the General forum.

No.

But you can use dsjob -jobinfo project jobname in your script and parse out the information you require.

Try XMETA.USERS_2 for users and XMETA.USERPROFILES_2 for roles and groups.

For lines that will never be more than a small multiple of 132, you could also use substrings onto multiple outputs of a Transformer stage (constrain each with an expression that guarantees existence of that line fragment) and combine those with a Funnel stage.

You can use a server job or BASIC Transformer stage in a parallel job and the Fold() function or the Fmt() function in either.

Do you want to break at the exact character boundary, or preserve whole words on a single line? Both are possible.

Yes you can, but using Complex Flat File stage is much easier.

Welcome aboard.

You can FTP the files to the AIX server, you could also access them as DB2/400 tables through ODBC or DB2 Connect.

The example i gave was just to for ur understanding. Ur was a city in ancient Babylon; it has not existed for thousands of years and is therefore probably beyond understanding anything - even assuming that a city can understand at all. The second person personal possessive pronoun in English is spe...

You can use a server routine. If $OPTIONS TIME.MILLISECOND is set, then SYSTEM(12) returns the current time in milliseconds since midnight, provided that the operating system supports milliseconds. FUNCTION NowMS(Format) $COPYRIGHT "Copyright (c) 2004, Ray Wurlod. All rights reserved. May be fr...

They should be hidden. Whatever your DataStage Administrator user ID is needs to have write permission to these files. It appears that you are using Access Control Lists as part of Windows security; the error message suggests that the user is attempting to change the ACL and lacking the requisite pr...

Gosh, and here's me thinking the original question was "is there a command equivalent".

Good point, but the same story is true whether you're using a Lookup stage or a Standardization stage - you need to include all partial forms in the lookup/classification table.