View previous topic :: View next topic
|
Author |
Message |
rajkumarmr
New User
Joined: 29 Sep 2006 Posts: 3 Location: hyderabad
|
|
|
|
My requirement is like I want a column name which has 100 characters to be printed'
It like
Code: |
TABLE FILE XXXZZZ
XXYYZZ AS 'THIS IS A TEST DATA TO INSERT COLUMN NAME WHICH IS VERY LENGTHY'
WHERE xxyy EQ '888'
ON TABLE HOLD AS EXTRACT FORMAT WP
END |
I have tried variable name after 'AS' keyword but it is not taking the value of the varaible, it is taking varaible name itself
Edited: Please use BBcode when You post some code/error, that's rather readable, Thanks... Anuj |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Quote: |
I have tried variable name after 'AS' keyword but it is not taking the value of the varaible, it is taking varaible name itself |
Was the variable name in quotes? It yes, please try without the quotes and let us know what happens. |
|
Back to top |
|
|
rajkumarmr
New User
Joined: 29 Sep 2006 Posts: 3 Location: hyderabad
|
|
|
|
The variable I used is not in quotes and it is giving varaible name in the output file not the value of it.
Even in the SYSPRINT there are no errors
Code I wrote is something like
SET AUTOTABLEF = ON
SET ASNAMES = ON
DEFINE FILE REC
WS_BSC/A44 = 'THIS IS A TEST DATA TO INSERT LENGTHY HEADER'
END
TABLE FILE REC
PRINT ACCT_NO AS 'ACCOUNT#'
BSC_CODE AS WS_BSC
ON TABLE HOLD AS EXTRACT FORMAT WP |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You might try something like this:
Code: |
WS_BSC/A84 = 'THIS IS A TEST DATA',
' TO INSERT LENGTHY HEADER',
' FOR A MULTI-LINE TITLE' |
I don't have access to Focus on a system just now, so this wasn't tested. I believe you are allowed up to 5 lines of title. |
|
Back to top |
|
|
rajkumarmr
New User
Joined: 29 Sep 2006 Posts: 3 Location: hyderabad
|
|
|
|
If I try varaible after AS, it is taking variable name and not the value.
So we should try the title directly after AS.
But the line continuation is not the comma for title.
So it does not work if I use
BSC_CODE AS 'LOAN DESC IJFSDFLM FMLSDFKSD',
'NFKSDNFLSDKFNLDSNFFSDLFLDSNSD' |
|
Back to top |
|
|
|