Converts a DB2 date, time, timestamp, ROWID, floating point, integer, or decimal value to a character value. SQL > SQL String Functions > Trim. This method takes the form of simply prefixing all db2 commands and queries with "db2", usually enclosing them in double quotes to avoid trouble with shell expansion. db2 register db2 server in ldap as paulb058 protocol tcpip hostname paulb058 db2 backup db SAACCNT tablespace TS01_4K_ACCNT online to /dev/null If any body asks you the tablespace size report in MB's. Now let’s look at an example of using REPLACE to replace one or more characters in a string with an actual value instead of nothing. SQL Loader will only read the data from Flat files. If you would like to know the count and the table name from one scheme I think that we can use for that some system view example query. Is there a simple tool like trim I could pipe my output into? Example file: test space at back test. The sample data contains 21,478 rows of data, with each row corresponding to a food source from a specific country. We will look at a series of COBOL functions in this handout. The result of this type of incorrect usage is a NOTE:in the SAS log.