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!

Register Log in
  • Congratulations SkipVought 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. toring

    "grep" search of Sybase procedures

    This site has many utility procedures, look for sp__grep. http://www.edbarlow.com/document/procedures/readme.htm
  2. toring

    substr Question

    SQL1 If there is an index on FE_F it will never be used (function on a column).
  3. toring

    How to convert Table data to Flat file in Sybase

    Another option is to utilize external file system access (ASE12.5). Then you can create a proxy table in the server who actually points to a file and write to it through standard SQL-statments (through a stored procedure if you wants to).
  4. toring

    selecting current date

    The clue here is that the datetime datatype are accurate to 1/300 second. It holds both a datepart and a timepart. So when you compare values with the getdate() function you tries to find values stored in the same moment. If you want to find values for a whole day in a datetime column you have...
  5. toring

    ECMap using stored procedures

    I have a a map who works allright with embedded SQL. "Select Once For Retrieval" in a rule and then "Fetch After Prior Select" in the next step. I want to switch to stored procedure call in ASE. The correct way to do it seems to change "Select Once For Retrieval&quot...
  6. toring

    ECMap EDIFACT mapping the UNH/UNT segments

    Hi all, A customer wants a number mapped in the datalement 62 "Message Reference Number" in the UNH (Message header) and UNT (Message Tail). When I do the mapping and tries to generate the map I will get the error "Field GENDET.FIELD_MIN cannot be a zero-length string&quot...

Part and Inventory Search

Back
Top