DSXchange

That looks more like a decimal(7,5) because you've got 7 digits in total with 5 after the decimal.

Precision is the number of digits.

Scale is the number of digits to the right of the decimal point.

With that, I vote to mark this topic resolved!

Ray, you were really close. Here is the command output from an 11.3 server. ------------------ Listing roles in ASB directory. ------------------ Role ID: "CMAdmin" Name: "Common Metadata Administrator". Role ID: "CMImporter" Name: "Common Metadata Importer". ...

When in doubt, try searching the documentation. Here is the support portal URL (as of today): https://www.ibm.com/mysupport/s/?language=en_US A quick search there reveals a useful technote: https://www-01.ibm.com/support/docview.wss?uid=swg21625366 And it says: Be sure to put the correct value for t...

You mentioned not saving the job, but you would have had to save the job in Designer before it would have compiled. Anyhow, make sure when you add the job to the schedule that the time you select is a few minutes out into the future. If it's 7:04 and you schedule it for 7:05 then the system may not ...

It's nice to know the calculation is documented!

I am not aware of such a parameter or setting for that, however, you would not have to run your job using the default to abort after 50 warnings. You could set it to abort after 1 or 2 warnings at run time. If this is a scheduled job, then you would need to reschedule it to alter the setting.

Suppose you have a parameter, and it can be any type of parameter that provides a value for your ODBC data source name, and you have referenced it in the ODBC Connector stage. When you run the job, DataStage will take the value and via the drivers will go read the .odbc.ini file located at the $ODBC...

This may not help with your error, but hopefully to answer your first question... If you are using ODBC, then the database server name (host name) or its IP address would be stored in the .odbc.ini file which is usually located under the $DSHOME directory on your DataStage server. Telnet or ssh to g...

I had not checked PATH before but it appears to be OK. All the Info Server paths are listed first followed by Windows system paths followed by some SQL Server paths. There are no references to ERwin in the PATH.

I will update this if I run across any clues. For now it is a bit of a mystery.

Has anyone else run into this? When I open a DataStage client and enter my info, after I click Login I get a pop-up window that says: Please wait while Windows configures CA ERwin Data Modeler Gathering required information... That takes 2 or 3 minutes then my DataStage client opens. This is a new W...

As a first step, review the detailed system requirements. Try this link, or if it doesn't work, then search. https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=7FE40FD076CF11E7ACE8EE5CF6073F72 You should find the list of supported data...

N/A and None should be safe answers! With a fresh install, you don't have any connections to other software defined. I don't even know what the mentioned software is. Perhaps it's something very, very old and specific to some other part of your organization.

The DB2 Connector stage has a few properties related to Schema Reconciliation that you can toggle but I doubt those are going to help you much in this case. A couple of ideas: 1) update your job properties and stage properties to disable Runtime Column Propagation, in case it is enabled, just to mak...

We do not include any APT environment variables on every job. If we hit some sort of unusual problem, then we will create a copy of the job for debugging purposes and start narrowing down the problem as needed. That process may or may not require special APT environment variables to be added. We do,...