topic Re: Parallel hint with SAP connector in App Development

Parallel hint with SAP connector

igorgois_ — Fri, 15 Jun 2018 20:46:50 GMT

Hello,

I am trying to execute a SQL command using a parallel hint with SAP Connector.

I have already tried:

1) the stripcomments = 0, tried

2) the parallel without space between / and +

3) use a variable with replace the '/*'

With no success!

I got this error:

Connector reply error: ERROR parsing query: Duplicate field names not allowed, field name:/!

The DBA says that this sql runs fine in the oracle database.

Any clue? Thanks in advance

My code:

set StripComments=0;

LIB CONNECT TO 'CNNSAP-ECC';

EKKO:

LOAD

Text(MANDT) As MANDT,

Text(EBELN) As EBELN,

Text(BSART) As BSART,

Date(AEDAT) As AEDAT,

Text(EKORG) As EKORG,

Text(EKGRP) As EKGRP,

Text(IHREZ) As IHREZ,

Text(LIFNR) As LIFNR,

Text(VERKF) As VERKF,

Text(ERNAM) As ERNAM,

Text(BUKRS) As BUKRS,

Text(FRGKE) As FRGKE,

Text(LOEKZ) As LOEKZ,

Text(KNUMV) As KNUMV,

text(EQ_WERKS) as EQ_WERKS,

WKURS,

Text(BEDAT) As BEDAT,

Text(ZTERM) As ZTERM;

SQL SELECT /*+parallel */

MANDT,

EBELN,

BSART,

AEDAT,

EQ_WERKS,

EKORG,

EKGRP,

IHREZ,

LIFNR,

VERKF,

ERNAM,

BUKRS,

FRGKE,

LOEKZ,

KNUMV,

WKURS,

BEDAT,

ZTERM FROM EKKO;

set StripComments=1;

Re: Parallel hint with SAP connector

petter — Sat, 16 Jun 2018 11:16:47 GMT

Try to do the hint with a end of line comment -- instead:

SQL SELECT --+parallel

MANDT,

....

...

Re: Parallel hint with SAP connector

igorgois_ — Sat, 16 Jun 2018 11:37:59 GMT

Hello Petter,

I forgot to mention that I also tried this one and got this error:

QVX_UNEXPECTED_END_OF_DATA: SQL_ERROR Unknown column name "--" field list. field list. f ield list. field list.

my code:

LIB CONNECT TO 'CNNSAP-ECC';

EKKO:

LOAD Text(MANDT) As MANDT,

Text(EBELN) As EBELN,

Text(BSART) As BSART,

Date(AEDAT) As AEDAT,

Text(EKORG) As EKORG,

Text(EKGRP) As EKGRP,

Text(IHREZ) As IHREZ,

Text(LIFNR) As LIFNR,

Text(VERKF) As VERKF,

Text(ERNAM) As ERNAM,

Text(BUKRS) As BUKRS,

Text(FRGKE) As FRGKE,

Text(LOEKZ) As LOEKZ,

Text(KNUMV) As KNUMV,

text(EQ_WERKS) as EQ_WERKS,

WKURS,

Text(BEDAT) As BEDAT,

Text(ZTERM) As ZTERM;

SQL SELECT --+parallel

MANDT,

EBELN,

BSART,

AEDAT,

EQ_WERKS,

EKORG,

EKGRP,

IHREZ,

LIFNR,

VERKF,

ERNAM,

BUKRS,

FRGKE,

LOEKZ,

KNUMV,

WKURS,

BEDAT,

ZTERM FROM EKKO;

Re: Parallel hint with SAP connector

petter — Sat, 16 Jun 2018 12:00:48 GMT

It might be that you have to use ~~ instead of --

What kind of SAP system, version and underlying database do you have?

Re: Parallel hint with SAP connector

petter — Sat, 16 Jun 2018 12:14:30 GMT

SAP ABAP SQL also supports hints as a last text after the actual SELECT statement like this:

SQL

SELECT <fields> INTO <work area> FROM <database table> WHERE <logical expression> AND <logical

expression>

%_HINTS <database name> 'INDEX("<database table>" "Index name")'.

;

Re: Parallel hint with SAP connector

igorgois_ — Sat, 16 Jun 2018 12:23:41 GMT

Hello, Petter

Thanks a lot for your instant help.

I tried now ~~ and got this:

Connector reply error: RfcAbapException:NOT_FOUND

Im not sure about the SAP info. What I know:

- I am connecting to SAP ECC

- Its a oracle database

- The string connection is:

CUSTOM CONNECT TO "provider=QvSAPSqlConnector.exe;servertype=0;ASHOST=saplccp2.removed.br;CLIENT=500;SYSNR=00;Timeout=3600;SNC_MODE=false;SNC_QOP=9;advancedProperties=true;ConvRoutine=false;CheckSeparator=false;Nulldate=true;RemoveAllBlanks=false;ReplaceNullvalue=true;Trace=false;MixedMode=false;NulldateLegacy=false;FLTPLegacy=false;TIMSLegacy=false;DataTypeLegacyMode=false;PacketSize=20000;FetchBuffers=99999999;BufferPercentage=10;TimeOutBatch=600;TimeOutFetch=1200;TimeOutStartBatch=2400;BatchJobName=/QTQVC/READ_DATA;TargetServer=saplccp2_CCP_00;JobClass=A;SocketBufferSize=32768;SenseVersion=12.20.10;"

If you need some other information, please let me know

Re: Parallel hint with SAP connector

petter — Sat, 16 Jun 2018 12:28:45 GMT

I am sorry - I am out of suggestions for now ....

Re: Parallel hint with SAP connector

igorgois_ — Sat, 16 Jun 2018 12:59:40 GMT

I will check with the DBA these infos to try this syntax

Thanks a lot for your help

Re: Parallel hint with SAP connector

igorgois_ — Tue, 19 Jun 2018 13:39:04 GMT

Here are the informations about SAP system

Re: Parallel hint with SAP connector

igorgois_ — Tue, 19 Jun 2018 15:02:16 GMT

I tried with this syntax:

SQL SELECT

MANDT,

EBELN,

BSART,

AEDAT,

EQ_WERKS,

EKORG,

EKGRP,

IHREZ,

LIFNR,

VERKF,

ERNAM,

BUKRS,

FRGKE,

LOEKZ,

KNUMV,

WKURS,

BEDAT,

ZTERM FROM EKKO

%_HINTS

ORACLE 'FULL(T_00) PARALLEL(T_00,18)'.

;

(https://archive.sap.com/discussions/thread/1790569)

and got this error:

QVX_UNEXPECTED_END_OF_DATA: SQL_ERROR Wrong expression "%" in FROM clause .