DSXchange

Which database are you using for IADB?

Which user is specified in the Analysis Database settings within Information Analyzer, both generally and at the project level?

Ordinarily the default settings are OK, since the user is creator/owner of any tables created during analysis.

In any number base 20 and 020 are the same value.

Read the text file and perform lookups against the table, either directly or a copy pre-loaded into a hashed file.

You can simulate parallel jobs using multi-instance server jobs, and/or using Link Partitioner stages within a server jobs.

In-place upgrade may not yet be available for version 9.1. The Concierge service will be all over this. Stay tuned.

Your Information Server documentation specifies that the only supported browsers are Information Explorer and Mozilla Firefox. Further there are version constraints; for example IE6 is not supported nor - officially - is IE10.

Check your Analysis Database settings both global and project. The SID specified is not one that Oracle recognizes.

Maybe your metadata are wrong, and AMOUNT is stored only in positions 11-19. The character in position 20 means something different, and should be read as a separate field.

I need a way to insert a row with a null value for a not null column so that the database uses the default value. This will not be accepted. The default value is only used when no value at all is supplied - that is, the column name does not appear in the columns list and no value for it appears in ...

dBase metadata are usually only "documented", which ultimately means that you have to retrieve them manually either from a document or from program code that accesses the data.

Yes, that's what I'm saying. A copy of the configuration file used to write the Data Set is stored in its descriptor file and this can be used to read the Data Set (the data then have to be automatically re-partitioned in to the nodes of the currently active configuration file). DataStage looks afte...

DataStage is alerting you to the fact that some dfloat values can not be stored in a decimal[17,2] column (because they are too large). You can choose to ignore/demote/suppress this warning only if you are 100% certain that every value you will be processing is legal for decimal[17,2].

Welcome aboard. Bienvenue. You can use a Folder stage for this purpose.

What's the key? How big (wide) are the rows? What hashing algorithm have you specified? What size for the hashed file? Get these right and you will be able to populate it faster.

Specify more precisely and we may be able to respond more precisely. We do not like wasting time guessing.