Archives of the TeradataForum

Message Posted: Mon, 12 Jul 2004 @ 18:12:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Rob,

Finally, it is working...

Here is the output:

     3186139,73,1623,6208,0
     2536513,17,231,6246,1
     6464892,6,76,6664,1
     5036796,1,2,6246,1
     4072568,283,3208,6010,0

Here are the changes I made to the script:

     SEL TRIM(DT1.NPANXXX) || ',' || TRIM(DT1.OWNER_MARKET_ID) || ',' ||
         TRIM(DT1.OWNER_CARRIER_ID) || ',' ||
         TRIM(DT1.OCN) || ',' || TRIM(DT1.MARKET_TYPE) (CHAR(40)) (TITLE '')

     FROM (SEL NPANXXX (FORMAT 'ZZZZZZZZZ9') (VARCHAR(10))
             ,OWNER_MARKET_ID (FORMAT 'ZZZZZ9')  (VARCHAR(6)),

               OWNER_CARRIER_ID (FORMAT 'ZZZZZ9')  (VARCHAR(6)), OCN (VARCHAR(4)),

               MARKET_TYPE      (FORMAT 'ZZZZZ9')  (VARCHAR(6))

          FROM DBNAME.TABLE_NAME) DT1;

Thanks again for the help...

Ganga Palakattil

	<Prev	Next>		<<First	<Prev	Next>	Last>>