Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. al1x24

    Convert CHARACTER to Date

    I think that select cast('20041101' as date format 'yyyymmdd') would give a better result.
  2. al1x24

    String concatenation...

    OOOPS,[hammer] I was too fast in my answer. If your value is 0, (FIELD_n (format 'Z(x)')) will return an empty string. Use trim(FIELD_n (format 'Z(I)9')) to be sure to get a '0'. Use (FIELD_n (format '9(x)')) when you want a fixed length completed left with '0'.
  3. al1x24

    String concatenation...

    Hi, I suppose your field_3..6 are defined as DECIMAL or NUMERIC. You have to FORMAT these values before concatenation. trim((FIELD_n (format 'Z(I)')) will answer your problem in a generic way. If you are sure aboout the length of your field, you can use a simpler (FIELD_n (format 'Z(x)'))...
  4. al1x24

    Integer to Number

    !!! Be carefull. Don't forget the sign. INTEGER is a signed type, with stores values between -2147483648 and 2147483647 So, if you cast to format '9(10)', the sign could be lost.
  5. al1x24

    Storing Graphics

    Larger than VARBYTES are BLOB columns, next page on your "SQL Reference: Data Types and Literals" manual ;-)
  6. al1x24

    How to compare DDLs/Indexes/Collect Stats between Databases?

    If your Databases are on the same machine, it will be easy to compare the structure of tables (column and indexes) via the DBC tables. Even collected stats can be compared by this way. If your db's are not on the same machine, I think the easiest way to compare structures is to extract tables...
  7. al1x24

    values for integer field

    INTEGER is a four bytes signed value. With a simple operation, you can verify that : 2150272280 + 2144695016 = 4294967296 with is equivalent to 2**(8*4). Idem with your other values. To store a value larger than the range of INTEGER, you have to use DECIMAL or FLOAT values. To convert your...
  8. al1x24

    remove fastload lock

    Before using the DROP solution, try to close your already opened fastload session : logon ... ; begin loading ... errorfiles ..., ... ; end loading ; logoff ; In most cases, it's enough to unlock your tables.
  9. al1x24

    remove fastload lock

    The first way I use to unlock a mis-fastloaded table is to close the fastload operation on this table with an empty fasload command. fastload <<-!Eof >> ${LOG_FILE} 2>&1 logon ${DWHTDP}/${DWHUSR},${DWHPWD} ; begin loading ${TBL_BASE}.${TBL_NAME} errorfiles ${TBL_BASE}.${TBL_NAME}_ER1 ...

Part and Inventory Search

Back
Top