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).
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...
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"...
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"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.