Skip to main content

Hi,

 

I'm trying to run this function:

EXEC SQL

SELECT REPLACE

      ('123456_FILE01_RESUMO.XLS', '_RESUMO', '')

    INTO :WS-LABEL-AUX-SAIDA

FROM DUAL

END-EXEC

 

TO RETURN: '123456_FILE01.XLS'

but it did not work in cobol net express 5.1

 

but, when I put spaces between the parameters it worked

EXEC SQL

SELECT REPLACE

      ('123456_FILE01_RESUMO.XLS',   '_RESUMO',   '')

    INTO :WS-LABEL-AUX-SAIDA

FROM DUAL

END-EXEC

 

Can anyone explain why?

 

Att,

Antonio.

 


#function
#SQL
#NetExpress5.1

Hi,

 

I'm trying to run this function:

EXEC SQL

SELECT REPLACE

      ('123456_FILE01_RESUMO.XLS', '_RESUMO', '')

    INTO :WS-LABEL-AUX-SAIDA

FROM DUAL

END-EXEC

 

TO RETURN: '123456_FILE01.XLS'

but it did not work in cobol net express 5.1

 

but, when I put spaces between the parameters it worked

EXEC SQL

SELECT REPLACE

      ('123456_FILE01_RESUMO.XLS',   '_RESUMO',   '')

    INTO :WS-LABEL-AUX-SAIDA

FROM DUAL

END-EXEC

 

Can anyone explain why?

 

Att,

Antonio.

 


#function
#SQL
#NetExpress5.1
Hi Antonio,

I think you are not up to date with Net Express 5.1's Update (or WrapPack if you prefer). I am running Net Express 5.1 with its latest update (Update 15 or 5.1.15), and I get the expected result.

Hi,

 

I'm trying to run this function:

EXEC SQL

SELECT REPLACE

      ('123456_FILE01_RESUMO.XLS', '_RESUMO', '')

    INTO :WS-LABEL-AUX-SAIDA

FROM DUAL

END-EXEC

 

TO RETURN: '123456_FILE01.XLS'

but it did not work in cobol net express 5.1

 

but, when I put spaces between the parameters it worked

EXEC SQL

SELECT REPLACE

      ('123456_FILE01_RESUMO.XLS',   '_RESUMO',   '')

    INTO :WS-LABEL-AUX-SAIDA

FROM DUAL

END-EXEC

 

Can anyone explain why?

 

Att,

Antonio.

 


#function
#SQL
#NetExpress5.1
Hi Antonio,

I get the expected result if I use the exact same code as above, but it doesn't work if the first parameter is a host variable.

Since you already have a support incident open with MF Support about this, I will let the support engineer who's working on it to follow up with you.

Hi,

 

I'm trying to run this function:

EXEC SQL

SELECT REPLACE

      ('123456_FILE01_RESUMO.XLS', '_RESUMO', '')

    INTO :WS-LABEL-AUX-SAIDA

FROM DUAL

END-EXEC

 

TO RETURN: '123456_FILE01.XLS'

but it did not work in cobol net express 5.1

 

but, when I put spaces between the parameters it worked

EXEC SQL

SELECT REPLACE

      ('123456_FILE01_RESUMO.XLS',   '_RESUMO',   '')

    INTO :WS-LABEL-AUX-SAIDA

FROM DUAL

END-EXEC

 

Can anyone explain why?

 

Att,

Antonio.

 


#function
#SQL
#NetExpress5.1
Exactly i use a host variable !

I'm waiting for the support response.

Thanks !
Terms & ConditionsAccessibility statement