Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Help on numeric values.
Hi
Can someone please help me with:
1) I need to zero fill numeric values, the PADL() functions seems to work with only character data types.
2) Unload all the fields in a table text delimited with comma delimiters seperating the fields, but the problem is that the fields must be unloaded in the same size than it is defined in the table.
Example: catalogue (XX12) - char(6) and lot number (453) = numeric, therefore it must be unloaded as "XX12 ",00453,
I am currently using the "COPY TO" command, but it seems that you cannot unload delimited and in fixed format?
3) Our COBOL program created a flat file which is comma delimited and the text fields are in quotes and the line is ended with a ','. To get the comma I added a dummy field to the table (numeric 1) to get the comma at the end of the flat file. The problem is now that the numeric field unloads a 0 (zero). I do not want a value to be unloaded. How can I get rid of that 0 and replace it example with a .NULL.
Thank you
Irene Grassow
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement