DSXchange

Thanks Craig for your response. The job design with a single STP stage. While the stored procedure defined insert into <table>.

Hi All, I have a stored proc running fine in sqlplus but not when called from datastage. Stored proc defined as 'Transform'. I ran the stored proc in sqlplus which inserted approximately 700 rows. However, when the stored proc calls from datastage, it generates zero rows. One thing i suspected is th...

Hi all experts, I have a query to execute as below, execute dbms_mview.refresh(#view_name#) I tried to run the query in datastage using Oracle Enterprise stage but failed due to "update statement prepare failed" error. Thus, I am thinking to plug the query to dynamic RDBMS stage. However, ...

Error message said,

BASIC_Transformer_6,0: dspipe_init(11338): open(/tmp/ade.HPBINFOHUBDEV.JB_KP_EX_LU_DATA_OWNER.#0.BASIC_Transformer_6.Lnk_Basic-Output) - No such file or directory

BASIC_Transformer_6,0: The runLocally() of the operator failed.

Hi All Experts, I have a ETL job which using BASIC transformer to call a routine. The job runs successfully for the first time. And subsequently, to run second time, the job seems running forever and up to certain period (20minutes), it will be aborted. I try to recompile the job again and it runs f...

I've no choice but accepted the crappy file structure

My bad, i should search the forum on horizontal pivot... but my DS has no pivot license.

Am trying to look for a solution by using routine.

I am aware of the function FIELD in transformer that FIELD(Lnk_InLoad.COLUMN1,';',1) will return the first value store before semicolon. However, I have a requirement which a column contained of multiple value separated by pipe. There is no fixed number of value will store within the column. header ...

Thank you very much

Hi there,

Understand that double quote is a special character.
May i know how to embed a double quote to a column?

eg. transformer read in columns from sequential file.
In one of the column i would like to concatenate double quote as "column1"

Thanks for the help

Hi All expert, Need your advice on how do i achieve on below scenario. Due to some constraint, sequential file is given in a format of (separate by delimiter --> "," 001","CEREL","29","1-yearly","1990 However in DS, I am require to include a double q...

sample data from sequential file,

001"|"John"|"6-Yearly"|"2009

However, in sequential stage, the setting is set to Delimiter String = | Quote = none Though I manually key in Delimiter String = "|" After I saved the job, the delimiter reads Delimiter String = | As well when running the job, it seems that delimiter is | because i hit the error SEQ_CORP,...

I just realized that double quote(") is a special character?

It seems that i've change delimiter string and input (double quote + pipe + double quote) "|" it doesn't recognize the delimiter as it is. it only appear (pipe) |

Need your advice.

Thanks.

Yes, it is oracle DB.
The datatype defined as NUMBER(6) in oracle.

The desired output was to display,
example: ETL_RUN_DATE = 20101024
YEAR_MONTH will display "201010"

Hi, I have a ETL job that hit below error, Column YEAR_MONTH floating point decimal is not fully supported; adjusting the scale. Column YEAR_MONTH has been modified in sql as TO_NUMBER(TO_CHAR(COMBR.ETL_RUN_DATE,'YYYYMM')) And the target column datatype has changed to integer or numeric still hittin...