Single Quote in Routine
Posted: Sun Mar 25, 2007 11:37 pm
Hi All,
In my routine (Basic) I am writing a sql script.
I am unable to get Single Quote
Routine Syntax
Thanks in advance.
Regards,
Munish
In my routine (Basic) I am writing a sql script.
I am unable to get Single Quote
Routine Syntax
The result:SqlScript = "SET HEADING OFF\n"
SqlScript = SqlScript:"Delete from ":TABLENAME:" Where ETL_KEY in\n"
SqlScript = SqlScript:"(Select ETL_KEY from OLB_ETL_LOAD_FACT where BATCH_ID in\n"
SqlScript = SqlScript:"(Select BATCH_ID from OLB_ETL_BATCH_FACT\n"
SqlScript = SqlScript:"where STATUS <> ":"COMPLETED":" ));\n"
SqlScript = SqlScript:" EXIT;"
What I want to get isSET HEADING OFF
Delete from EDX_RPT_SERVICE_DETAIL_FACT Where ETL_KEY in
(Select ETL_KEY from OLB_ETL_LOAD_FACT where BATCH_ID in
(Select BATCH_ID from OLB_ETL_BATCH_FACT
where STATUS <> COMPLETED ));
EXIT;
How to improve my routine (Basic) to get that???SET HEADING OFF
Delete from EDX_RPT_SERVICE_DETAIL_FACT Where ETL_KEY in
(Select ETL_KEY from OLB_ETL_LOAD_FACT where BATCH_ID in
(Select BATCH_ID from OLB_ETL_BATCH_FACT
where STATUS <> 'COMPLETED' ));
EXIT;
Thanks in advance.
Regards,
Munish