DSXchange

Tried using the dummy environment variable with $ symbol and it gives error message. And tried assigning this env variable to the argument and it gives error.

Can you pls share us how the env variable can be assigned to Argument of the routine.

Thanks for the inputs.

Regards
Saravanan

Hi Roy,

Thanks for suggesstions.

I will search in the forum.

Regards
Saravanan

Hi, We are maintaining a separate project for the testing and due to security reasons the project was made as 'Readonly'. We make the changes in the devt project and migrate the changes into our test project. While importing the jobs into the test project (We made the project as Non-Readonly then im...

Ensure that the 'suppress warning message' (Not so sure abt the option) in the input tab of Sequential file stage and warning messages will not be shown if this option is selected.

HTWH.

Regards
Saravanan

Enable 'APT_DUMP_SCORE' to true using 'Administrator client' and it will show the partitions and the operators while running the job.

HTWH.

Regards
Saravanan

When 'Auto' is used as the partition type, PX engine will use the appropriate partition based on the input and the operator that is defined in the job. You can look at the generated OSH to find out which partition is used in the job.

HTWH.

Regards
Saravanan

Stored procedure can be created to achieve this and the same SP can be called from a DataStage job.

HTWH.

Regards
Saravanan

Jobs can be unlocked using DS Director. Select the job in Director and click on Tools and Cleanup Resources. Look for the job and get the PID from the Locks window and select the PID from the processes and select 'Logout all' or 'Release All' to release the job.

HTWH.

Regards
Saravanan

Date can be loaded into a DB2 table if the column's data type is defined as char(10) and it required to be the same format as defined in the database.

HTWH.

Regards
Saravanan

You can use stage variables to eliminate duplicate records. This topic was covered lot. Pls search the forum.

Regards
Saravanan

IConv & OConv functions cannot be used in Parallel transformer unless BASIC transformer used in a parallel job.

Regards
Saravanan

Muliple job compile options is available in 7.5, which will help you to compile all jobs in a project. Is there any special req to compile the jobs using commands.

HTWH.

Regards
Saravanan

If you find ReadOnly "0" means those objects are not readonly. Did you check the projects folder whether you have write permissions on that folder.

Regards
Saravanan

Hi Naveen,

The objects are not readonly. Can you check the DSX file for the strings (like 'J\8\V0S0P1') and check these DSRECORD are made as 'READONLY'. If readonly is yes, then you can find entry as READONLY "0".

Regards
Saravanan

It seems to me the objects in DS_JOBOBJECTS are made readonly. Pls verify the objects are readonly by executing this command in Administrator. SELECT DISTINCT READONLY FROM DS_JOBOBJECTS. If it returs 'RO' that indicates the all the objects are made readonly. Pls change the 'RO' to non-readonly then...