Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I have connected to QvSAPDSOConnector. I am trying to pull an infoObject from a particular DSO and rename it into a business specific format. I am trying to alias the fields in the select statement. But an error is thrown
Type: 'E', Message: 'InfoObject AS in the list of available InfoObjects does not exist in DS'
The code I am using is
[ZCR_OCOM]:
Load *;
SQL Select
0CRM_ACGUID AS ABC
from ZCR_OCOM;
Store * from [ZCR_OCOM] into ZCR_OCOM.QVD;
Drop table [ZCR_OCOM];
please help me with this.
Hi All,
This issue is solved.
I tried to load with alias name and then select. It is working fine now.
[ZCR_OCOM]:
Load [0CRM_ACGUID] AS ABC ;
SQL Select
0CRM_ACGUID
from ZCR_OCOM;
Store * from [ZCR_OCOM] into ZCR_OCOM.QVD;
Drop table [ZCR_OCOM];
Thanks every one.
Hi All,
This issue is solved.
I tried to load with alias name and then select. It is working fine now.
[ZCR_OCOM]:
Load [0CRM_ACGUID] AS ABC ;
SQL Select
0CRM_ACGUID
from ZCR_OCOM;
Store * from [ZCR_OCOM] into ZCR_OCOM.QVD;
Drop table [ZCR_OCOM];
Thanks every one.