The UNIX and Linux Forums  


Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #4 (permalink)  
Old 04-22-2009
ryanW ryanW is offline
Registered User
  
 

Join Date: Mar 2009
Posts: 34
Thank you devtakh and giannicello...

the sample you teach me.. still the same.
I think in the string for data_type_SQL after selected from database already wrong with SIZE.

The error according with the TABLE name size LOC_TYPE in 8,WAREHOUSE in 9 and LOCATION_ID in 11.

so, data_type_SQL = |G*******|NRT*****|NRTW*******| <-- it is wrong, coz it is follow with the table name of size.

suppose to be in its own size

LOC_TYPE(1)
WAREHOUSE(4)

LOCATION_ID(6)

the correct one should be
data_type_SQL = |G|NRT*|NRTW**|

Do you clear what i am explain?
SOS

Thank you...