DSXchange

Hi ray:

I was not able to view the routine code. Can you pls. post me the routine code?

Hi, I have jobs and job sequences in my project. I want to extract the job heirarchy in my projecy. Example: Job Info: Job1, Job2,job3, job4, routine1 Seq Info: Seq1 (has job1, job2) Seq2(has job3, seq1, job4, routine1). Now i want a query to have the below the structure(job tree). Seq2 Job3 Seq1 Jo...

Hi, I use the below function to fetch the data for the cuurent timestamp. Oconv(@DATE,"D-YMD[4,2,2]") :' ': Oconv(@TIME,"MTS"). The job is inserting the same value for all rows. Example: the job takes 5 mins to execute. but the timestamp for all rows is same, which is not. Some r...

Hi Ram: I am not using ODBC, i want to avoid this steps as i have all my other jobs executing using "Dynamic RDBMS". I used the "Stored Procedure" option while updating the dictionary and used the name of the stored procedure in the "Stored Procedure" option in the Data...

Hi, I have one stored procedure in Oracle to refresh all the materialized views in the schema. This stored procedure takes no input. when i execute the job i am getting the following error "Active Stage has no inputs or outputs". I don't wnat to execute in sqlprompt or call sqlplus from ro...

Hi All:

It is working fine.
But I have a doubt on this. If we have a "&" in the values clause the oracle will go for the Prompt "Enter Value for" considering the value after "&" as variable.
This is the case in sqlprompt execution of the Oracle scripts.

HI,

I am using the oracle as teh target database. I have to insert "&" ampersand into the database. But oracle will consider it as the special character how do i insert the data.

Hi Ray: I do the etl jobs on dev env and when i migrate them to Testing or production i use the export option to move the project from dev to test/prod. At the time of import i get all the variables defined at the project level. But if i look in at the DSParams file in the project directory for the ...

Hi, I am writing a server code to add env variable to the existing project. I was looking at the development kit section and i have noticed the DSAddEnvVar API in the that section. But when i do the routine code i get the follwoing error. Array 'DSAddEnvVar' never dimensioned. I get a zero result se...

Hi,

If I use the Hashfile, how do i do the query in the routines by passing the filters. I don't want to look for the occurence of the filter value and put an exit condition. Do u have any sample model on how u do a search from the hash file.

Hi,

I want to create a new table in Datastage repository for my project, it iwll hold the metadata of my job processing(customized) for which i create a table and do fetch the data in the routines using the select statments as what we do to get the repository info(Example job info DS_JOBS).

Hi Nick: The usage of the parameter is giving error. it specifies you have to pass either a ASCII code or Hexa. The same is for the quote also.I can't have e different quote character. for null quotes i have to specify 000. I want to parameterize so that i can execute for whichever delimiter i want ...

Hi, I have requirement, where the sequential file generated as same output file with different delimiter values say (|,~,-). This i have to give for different datamarts. Now If I pass the delimiter value as a job parameter it will help me to use one job to generate the files (for n number of delimet...

Hi, Does the dstage OS group necessary for the installation of the DS7.X. Say in while installing ORACLE it will ask for the group, here i can give any value(need not be dba, oinstall). The root.sh will configure the install with the new group. Will the same happens here in DS install or i have comp...

Hi,

I want to use the command line or wants to write a DS Routine to change the default values of the all jobs in the project.