[sqr-users] Error running an

["Bollepally, Rajesh X." <rajesh.bollepally@nscorp.com>]

Hi,

 I have got this error:

 

(SQR 5528) ODBC SQL dbsql: SQLPrepare error -3535 in cursor 1:

   [NCR][ODBC Teradata Driver][Teradata Database] A character string
failed conversion to a numeric value. 

 

SQL: SELECT (( CASE WHEN   TAXI_ORDER.TAXI_ORGN_NM  IS NULL  THEN   (
ltrim(

       rtrim( TAXI_ORDER.TAXI_ORGN_CITY )  ) || ' , ' ||   ltrim(
rtrim(

     TAXI_ORDER.TAXI_ORGN_ST )  )  ) ELSE  TAXI_ORDER.TAXI_ORGN_NM  END
)),

     ((  CASE WHEN   TAXI_ORDER.TAXI_DEST_NM  IS NULL THEN (    ltrim(  

     rtrim(  TAXI_ORDER.TAXI_DEST_CITY )  )   || ' , ' ||     ltrim(
rtrim(

     TAXI_ORDER.TAXI_DEST_ST )  )  ) ELSE  TAXI_ORDER.TAXI_DEST_NM  END
)),

     (sum( case when Taxi_Order_Invoice_Xref.Item_Desc = 'RTripMI' then

     Taxi_Order_Invoice_Xref.Item_Qty else 0 end)), (sum( case when

     Taxi_Order_Invoice_Xref.Item_Desc = 'WtTime' then

     Taxi_Order_Invoice_Xref.Item_Qty else 0 end)),

     NS_CREW_CALL_PV.TAXI_ORDER.DIV_NR,

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_VEND_CD,

     NS_CREW_CALL_PV.TAXI_ORDER.TERR_CD,

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_ORDER_ID,

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_LN_SEGMNT, REQ_TAXI_PU_DT,
TRAIN_ID,

     DISPATCH_DT, EMP_NM, TAXI_SVC_TYPE, PULL_CD  From 

     NS_CREW_CALL_PV.TAXI_ORDER, NS_CREW_CALL_PV.TAXI_LOC_PAIR ,     

     NS_CREW_CALL_PV.TAXI_LINE_SEGMENT,
NS_CREW_CALL_PV.TAXI_ORDER_PSGR_H,

     NS_CREW_CALL_PV.TAXI_ORDER_LEG ,     

     NS_CREW_CALL_PV.TAXI_ORDER_LEG_PSGR,

     NS_CREW_CALL_PV.TAXI_ORDER_INVOICE_XREF,

     NS_CREW_CALL_PV.TAXI_ORDER_ACK_H Where

     NS_CREW_CALL_PV.TAXI_LINE_SEGMENT.TAXI_LN_SEGMNT =

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_LN_SEGMNT And

     NS_CREW_CALL_PV.TAXI_LOC_PAIR.ORGN_TAXI_LOC_ID =

     NS_CREW_CALL_PV.TAXI_ORDER.REQ_TAXI_ORGN_LOC_ID And

     NS_CREW_CALL_PV.TAXI_LOC_PAIR.DEST_TAXI_LOC_ID =

     NS_CREW_CALL_PV.TAXI_ORDER.REQ_TAXI_DEST_LOC_ID And

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_ORDER_ID =

     NS_CREW_CALL_PV.TAXI_ORDER_PSGR_H.TAXI_ORDER_ID And

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_ORDER_VERSION =

     NS_CREW_CALL_PV.TAXI_ORDER_PSGR_H.TAXI_ORDER_VERSION And

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_ORDER_ID =

     NS_CREW_CALL_PV.TAXI_ORDER_LEG.TAXI_ORDER_ID And

     NS_CREW_CALL_PV.TAXI_ORDER_LEG.TAXI_ORDER_ID =

     NS_CREW_CALL_PV.TAXI_ORDER_LEG_PSGR.TAXI_ORDER_ID And

     NS_CREW_CALL_PV.TAXI_ORDER_LEG.LEG_SEQ =

     NS_CREW_CALL_PV.TAXI_ORDER_LEG_PSGR.LEG_SEQ And

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_ORDER_ID =

     NS_CREW_CALL_PV.TAXI_ORDER_INVOICE_XREF.TAXI_ORDER_ID And

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_ORDER_ID =

     NS_CREW_CALL_PV.TAXI_ORDER_ACK_H.TAXI_ORDER_ID And (DISPATCH_DT >=

     '01/01/07' And DISPATCH_DT <= '01/15/08' And

     NS_CREW_CALL_PV.TAXI_ORDER.DIV_NR IN ('VA')) Group By (( CASE WHEN


     TAXI_ORDER.TAXI_ORGN_NM  IS NULL  THEN   (   ltrim(   rtrim(

     TAXI_ORDER.TAXI_ORGN_CITY )  ) || ' , ' ||   ltrim(   rtrim(

     TAXI_ORDER.TAXI_ORGN_ST )  )  ) ELSE  TAXI_ORDER.TAXI_ORGN_NM  END
)) , 

         ((  CASE WHEN   TAXI_ORDER.TAXI_DEST_NM  IS NULL THEN (
ltrim(  

     rtrim(  TAXI_ORDER.TAXI_DEST_CITY )  )   || ' , ' ||     ltrim(
rtrim(

     TAXI_ORDER.TAXI_DEST_ST )  )  ) ELSE  TAXI_ORDER.TAXI_DEST_NM  END
)) , 

         NS_CREW_CALL_PV.TAXI_ORDER.DIV_NR ,     

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_VEND_CD ,     

     NS_CREW_CALL_PV.TAXI_ORDER.TERR_CD ,     

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_ORDER_ID ,     

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_LN_SEGMNT ,      REQ_TAXI_PU_DT ,


     TRAIN_ID ,      DISPATCH_DT ,      EMP_NM ,      TAXI_SVC_TYPE ,


     PULL_CD Order By NS_CREW_CALL_PV.TAXI_ORDER.DIV_NR ,     

     NS_CREW_CALL_PV.TAXI_ORDER.TAXI_VEND_CD ,     

     NS_CREW_CALL_PV.TAXI_ORDER.TERR_CD 

 

Error on line 102:

   (SQR 3722) Could not set up cursor.

 

SQR: Program Aborting.

 

Thanks,

Rajesh Bollepally

Brio Developer

Application Development - Myers

404-253-3782

 

"Do not let what you cannot do interfere with what you can do." 

-- John Wooden,  

    legendary college basketball coach UCLA( 1960s to 70s)

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users