Joined: 20 Nov 2008 Posts: 14 Location: California USA
Hi,
I am running a spufi in batch mode and creating a flat file as an output.
Following is my query
Code:
UNLOAD TABLESPACE DB2 FORCE
LOCK NO QUIESCE YES QUIESCECAT NO
SELECT EMP_ID,
EMP_Dept_No
FROM EMP-TABLE
WITH UR;
OUTDDN (SYSREC00)
LOADDDN SYSPUNCH
FORMAT USER (
COL 1 NULLID NO TYPE CHAR(9),
COL 2 NULLID NO TYPE CHAR(9),
First two fields in the table are defined as S9(9) usage comp. In the ouput file I am getting leading spaces. I want leading zeroes instead.
Can you please guide me?
Thanks
Edited: Please use BBcode when You post some code, that's rather readable...Anuj
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Quote:
Anuj I am sorry but I dont know how to use BB code
At the top of the Reply panel are the "tags". Near the middle is the "Code" tag.
To use the Code tag, you can copy/paste your source, highlight the source, and click "Code". To see what your post will look like to the forum, click Preview. When you are satisfied with the appearance of your post, click Submit. In addition to readability, Code preserves alignment so you do not need to try to "space" things out to line up. Code also works well for jcl, utility control statements, and data.