Hi All -
Thanks for taking time to read my question / post.
I'm a beginner in using Teradata and after searching the web for any insight or guidance, I'm still lost.
How do I customize the format of the column results that I query below pertaining to an item UPC...
** For Example **
Here's another example of the UPC data that I'm having a problem with.
Any thoughts or ideas?
/** ITEM RECAP **/
PI_ITM_CD AS ITEM_NBR,
PI_UPC_CHK_FL AS UPC_CHK_FL,
PI_UPC_NBR_SYS_CD AS UPC_SYS_CD,
PI_POS_MFG_ID AS UPC_MFG_CD,
PI_POS_CASE_ID AS UPC_CASE_CD,
PI_POS_UNIT_ID AS UPC_UNIT_CD,
PI_BRND_DESC AS BRAND,
PI_ITM_DESC AS DESCRIPTION,
PI_ITM_PCK_QTY AS PACK,
PI_SIZE_TXT AS SZ,
Hi, This should work.
Sel CAST(CAST(1 AS FORMAT'-9(2)') AS CHAR(2))
For PI_UPC_MFG_ID, PI_POS_CASE_ID, & PI_POS_UNIT_ID
Sel CAST(CAST(1 AS FORMAT'-9(5)') AS CHAR(5))