Joined: 20 Nov 2008 Posts: 14 Location: California USA
I am running a spufi in batch mode and creating a flat file as an output.
Following is my query
UNLOAD TABLESPACE DB2 FORCE
LOCK NO QUIESCE YES QUIESCECAT NO
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?
Edited: Please use BBcode when You post some code, that's rather readable...Anuj
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.