DSXchange

Hi Arndw, Return error for all the commands of the dsjob Syntax: C:\Ascential\DataStage\Engine\bin\dsjob -lprojects Status code = 81011 ---------------------------------------------------------------- C:\Ascential\DataStage\Engine\bin\dsjob -run DStage CHash ERROR: Failed to ope project Status code ...

I am trying to execute a job with the command dsjob and return the error: Failed to open project - Status code = 81011

The job execute in DataStage GUI with sucess. Can anyone may help me?

Thank you in advance

You can import metadata from the ODBC, but the best option is to use Orchestrate Schema Definitions.

Importing Table Definitions:
Can import using ODBC or using Orchestrate schema definitions
- Orchestrate schema imports are better because the data types are more accurate

Hi,

I am seeking a book about Master Data Management. Can anybody indicate myself a book and where can I buy it?

Thank you

I am not getting to configure the .odbc.ini file in the solaris. Can anybody help me, posting an example?

Thank you.

Hi Craig Hulett

I have a job that makes a lookup in the hash before creating it. The hash is created in this job, then I needed to execute the command mkdbfile. I didn't get to configure in the GUI. Can you explain better as configuring?

Thank you

To create a hash in a specific directory, execute the command: mkdbfile path/HashFileName 30 1 4 20 50 80 1628 or create a routine: Call DSExecute("UNIX","ls ":PathHsh:"HashName", Output, SystemReturnCode) If SystemReturnCode <> 0 Then commandUV = "mkdbfile ":...

It is possible to configure the odbc.ini file to access the database postgres through DataStage 7.5?
Do I have to install some driver or DataStage already possesses the driver?

Any suggestions would appreciated

Thanking you all in advance

The pivot stage reads 1 row with 4 columns and it generates 4 rows with 1 column. If you you want to read multiple rows (1 column) into single row with the content of the column field1 of all rows, use ROW MERGE stage, but include transforms stage before the row merge stage for connects ";"...

Go to DataStage Administrator and execute this in the command: select * from DS_JOBS where NAME = 'Arquivo' Return: Job name .... Arquivo Description.. No.............. 55 Category..... Testes If you don't visualize it in DataStage Manager, you can delete all references of the job with the commands ...

You are correct. The plug-in of QS for DS doesn't allow two input files. Workaround: If your server DataStage and QualityStage goes the same, make a job DS generating the files in the directory "Data" of the project, and in this same job, create a routine that executes the job QS through c...

I will add new fields in blocking phase and to execute the job again.

I believe that is quite so. In the documentation of QualityStage (userGuide), it recommends that the blocks have approximately 10 to 20 records per file and that it should not exceed 100 records.

Thank you.

I am trying to execute a job QualityStage - MATCH among two files with 700 thousand lines, but return error: Error from Run: Error exec: E:/Projects/ERP/Logs/MADNECPV.MTC.StepMTCH_1.log:mtch(8084):6/21/2006 12:40:46 PM (MSG_mtch.c:1;mtch.c:2236) ERROR: Linear sum assignment overflow caused block ove...

I have a job in the version 4.2 that records the date of the system at format YYYY-MM-DD in the bank Oracle. I used the function Oconv to define the format. I migrated this job for the version 7.5 and when executing, the date was not recorded. I altered the function Oconv to record at format YYYY-MM...