DSXchange

Can you please post the "job started" event from the job log (or status) view so that the actual value passed to the parameter may be recognized? And, when you do, please verify that the SQL is both complete and as you intended. Hi Roy, In Job started event in job log, I am getting the va...

Is your job parameter of type String? Post your actual expression used when setting the job parameter. You may need to remove @FM characters from the command output. Hi, My Job Parameter is of string type. In execute command activity I have given the command cat and the parameter is the file path w...

Is your job parameter of type String? Post your actual expression used when setting the job parameter. You may need to remove @FM characters from the command output. Hi, My Job Parameter is of string type. In execute command activity I have given the command cat and the parameter is the file path w...

Use a job parameter for the entire SQL statement. Mark the SQL type "user defined". Use an Execute Command activity to read the file and pass the output of that command, stripped of line terminators (or equivalents) as the value for the job parameter. Hi Ray, Thanks for your input. I am p...

Maveric wrote:Pass the SQL as a parameter. Read the statement from the file in the sequence and pass it to the job.

Hi Maveric,

In job how the file can be read which contains SQL in database stages ?

Could you please give an idea of job design to raed SQL file from datastage.

Thanks,
Parameswar

Hi All,

I have to extract data from oracle tables. SQL is given in a .txt file. How can I read that file from Oracle stage instead of copying the SQL to extract data from tables? Is there any other stage supports to extract data from table by reading the sql file ?


Thanks,
Parameswar

Hi,

I have source data in float type and values are coming in the format 1.01177e+12. I need to convert to decemal type with proper value.

Please suggest what to do. Is there any inbuild function/ routines to convert it? I tried dfloattodecimal(), but it is not working.

Thanks,
Parameswar

Looks like you're going to need to find another place to do these deletes. The close command must wrap stuff up in an anonymous block and thus, when the delete finds nothing to delete, throws the 'no data found' error. Hi Chulett, Thanks for your reply. Close command is deleting the records. There ...

Hi All, I have a scenario like this: I have to load data into orcale. After loading,it will delete some records based on some condition. So in close command I have given delete statement. Job is loading data as well as deleting also, but status of the job is Failed. Error is as given below: Oracle_E...

What options did you compile your C++ routine with? I had a similar problem before and it was resolved when I recompiled without any extended compilation options. (not the datastage job, but the routine itself). Hi Michaeld, I am using the following command to compile c++ routine: /opt/aCC/bin/aCC ...

What options did you compile your C++ routine with? I had a similar problem before and it was resolved when I recompiled without any extended compilation options. (not the datastage job, but the routine itself). Hi Michaeld, I am using the following command to compile c++ routine: /opt/aCC/bin/aCC ...

Hi All, I have created a c++ program which does sum of two number. I created object file from it and created parallel routine. I am calling this from datastage job. While I am compiling the Job , getting following error. ##I TFSC 000001 16:54:36(006) <main_program> APT configuration file: /dspx00/As...

I had to do the same for one of my clients. I ended up writing a macro for creating ddl from the spreadsheet, executed in a temp oracle schema and imported the metadata from there. The number of tables was pretty huge, so it was worth the one time effort :) PS : The tool was not Datastage, so there...

Hi Can you paste the error message, it would be use ful to give a solution for your query.. As normal way to import metadata..just follow shivajid2k steps. Thanks for your reply. Actually I am not getting any error in importing column definition. I am clearly defining the requirement again: I have ...

Hi, I have to import column definition from csv file. File structure is given as below: Column Name,Type,Size,Constraint ID,Number,10,Primary Key C_ADDR1,Char,80, C_ADDR2,Char,80, C_ADDR3,Char,80, C_CITY,Char,25, C_CNTRY,Char,5, There are 180 columns in this file. Please help me if there is any way ...