We are using unload utility to unload the data from the tables and sort the extracted data as per the req
Found that there is null issue accuring for the 2 columns mentioned
Pls find the code used for the same
1. Th code mentioned below is used to extract first name from the name and save it as varchar(15)
Code: Select all
CAST(RTRIM(SUBSTR(ColumnName,1,LOCATE(' ',ColumnName)-1))
AS VARCHAR(15)),
Code: Select all
(REPLACE(CAST(TRIM(ColumnName)
AS VARCHAR(14) ),'.','')||'"'
Found that the query is giving null space for eg as shown below
Code: Select all
PRADEEPnulnulnulnulnulnulnulnul
The same is the case with the other column
The target system is not accepting the file because of this issue.
Could you please help us resolve this issue
Regards,
Pradeep