DSXchange

The General forum is where you post when you're not sure. Post there and we'll do something about answering. Don't include "ASAP" or "urgent", however. We don't do those. DSXchange is an all-volunteer site - people post as and when they can. If you want urgent help, sign up for premium service with ...

That's a good point. Will include a rider about the Data Direct drivers in any BCI code posted in future.

can we omit the later part i,e' records' and allow it to display only the value like 1500. Use the -n option of the dsrecords command. dsrecords -n /app/Ascential/DataStage/Projects/MyProject/Controls/MyDataSet.ds Best Practice Tip Create a directory in your project in which all descriptor files fo...

Simply because it does so much more work. C++ code is NOT generated for the whole job as you assert - all that is generated is an OSH script that is a one-to-one mapping of the stages in your design. Transformer and Build stages do have to compose, compile and link C++ code which is more time consum...

I don't think that's right, because changing to "" in Administrator had no effect.

Are you clicking Cancel (rather than OK) to close the Administrator windows?

It is not necessary to re-start services, but it might be interesting to open a new Administrator client after making these changes.

An out-of-band null is DataStage's internal representation of null. It's a single byte with only the high bit set (128 if it were a uint8). An in-band null is a value that is legal for the domain of the field, but which your business model has designated will represent "unknown". For example you may...

The functions themselves are documented as returning specific data types. Importing table definitions can not help with the data type returned by any function you may choose to use in your SQL. You can, of course, research the data type and amend the imported table definition or the columns within t...

Teej wrote:(and others that I may have not thought about.)

Still thinking about getting it to make lunch, I'll warrant.
Do you get a banquet if you use a parallel job?

IBM offers class code DX800 (What's New in DataStage/QualityStage 8.0) that has pretty good coverage. Talk with IBM Learning Services. This is not a regularly scheduled class - it is run on demand.

My location as stated is always correct. So, yes, currently I am in Bangalore.

Not a problem with DataStage. When you send arrays to Oracle and there's a problem with one of the rows, Oracle effectively reports "there was a problem with one of the rows in that array". The only way to isolate the row in which the problem occurred is to use array size of 1. Oracle still behaves ...

Use QualityStage - this is precisely the kind of thing (OK, one of the things) it's designed to do. It even correctly figures out that 125 ST STEVEN ST should be 125 SAINT STEVEN STREET. The technique is called standardization. A QualityStage standardization task can be included in a DataStage job f...

The Data Direct drivers are not meant to be used with BCI, only from stages. They are licensed that way. What's really annoying is that they work OK for 30 days before giving this message. If you want to go the BCI route you will need to provide your own ODBC drivers or license the Data Direct drive...