DSXchange

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

just4u_sharath wrote:Hello,

SELECT SKU_ID FROM REF_SRS_PRODUCT_SKU WHERE SKU_ID LIKE '%?%'

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.

If error persist then its problem with data else its a problem with displaying the data.

Thanks
Nitin Swarkar

I have converted sku_id column to varchar using cast function. Now i am getting the data..

SELECT DIV_NBR, ITM_NBR, cast( SKU_ID AS varchar(255) ) as SKU_ID From SRS_PRODUCT_SKU;


thanks for the reply