Hello,
I am extracting data from a table using netezza database stage. I am not getting any data.
If i give only 2 columns ITEM, DIV in table definition. But if i add SKU_ID I am not getting any data. I am guessing its problem with data. SKU_ID is an integer. I have even put a varchar but still it does not give me the data.
ERROR:
APT_ParseError: In field "SKU_ID": In property list: Expected property name, value, or "}", got: ",", line 4
Expected ";", got: <eof>, line 7
Expected ";", got: <eof>, line 7
Error parsing schema: Expected ")", got: <eof>, line 7
RT_SC103/OshExecuter.sh: line 25: 8869 Aborted (core dumped) $APT_ORCHHOME/bin/osh "$@" 2>&1
when i querry the table for wierd characters its not returning any data
SELECT SKU_ID FROM REF_SRS_PRODUCT_SKU WHERE SKU_ID LIKE '%?%'
I tried ? , " etc
Plz help
No data from view data
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
Re: No data from view data
Check the SQL in Netezza stage, after adding the SKU_ID column and execute same on the database, outside the datastage and check if you are getting same error.just4u_sharath wrote:Hello,
SELECT SKU_ID FROM REF_SRS_PRODUCT_SKU WHERE SKU_ID LIKE '%?%'
If error persist then its problem with data else its a problem with displaying the data.
Thanks
Nitin Swarkar
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan