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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by toring

  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...
See more

Part and Inventory Search

Back
Top