T24: How to use Select list IN DL.DEFINE

2,030 views
Skip to first unread message

ankit

unread,
Oct 15, 2008, 12:33:48 PM10/15/08
to jBASE
Hi All,

* I have used DL.DEFINE before but this time I want to used a saved
list to populate the FILE NAME and the
RECORD NAME.

*This is how I have created the saved list.

jsh bnk ~ -->SELECT @ID F.HELPTEXT.MAINMENU

37 Records selected

>SAVE-LIST HELPTEXT.MAINMENU
37 record(s) saved to list 'HELPTEXT.MAINMENU'
jsh bnk ~ -->

* When I use the saved list HELPTEXT.MAINMENU in DL.DEFINE the only
thing populated is the file name field ( with the record names ). So
instead of populating both FILE.NAME and RECORD.NAME , it only
populates FILE.NAME that to with the value of recored.name.


Thank you,
Ankit.



Santosh

unread,
Oct 15, 2008, 3:30:41 PM10/15/08
to jB...@googlegroups.com
Hi Ankit,
 
It will not work like that. Do the following steps:
 
SELECT F.HELPTEXT.MENU
SAVE.LIST TEST.HM
JED &SAVEDLISTS& TEST.HM
You can see all the HM ids in that. You need to prefix with HELPTEXT.MENU>HM ID You need to do for each record in the SAVEDLISTS.
 
Now go to DL.DEFINE and there is a field to define the SAVEDLISTS. If you specify TEST.HM that will populate with File name as HELPTEXT,MENU and record id as HELPTEXT,MENU id.
 
Remember the format in SAVEDLISTS must be FILE.NAME>RECORD name then only your file name and record name will populate correctly in DL.DEFINE.
 
Try and let me know if you need any details

--
Mobile: 973-39406098

Ashok Pandey

unread,
Oct 15, 2008, 3:17:41 PM10/15/08
to jB...@googlegroups.com
Ankit,

if you give save list system will split the content in two parts with separator  '>'

1st part as a file name and 2nd part as a record. Hence your data are populated into file name field.

Probably you should do like this

- Extract the all record in excel and add HELPTEXT.MAINMENU>
- jed &SAVEDLISTS& <file name>
- paste the data from excel
- save it and put the savelist name in DL.DEFINE

if you save the data into savelist directly from the jbase level, stores only particular records and  system will not identify that record belongs to which application.

ex:
jed &SAVEDLISTS& <file name>
HELPTEXT.MAINMENU>abc
HELPTEXT.MAINMENU>xyz


Cheers
Ash
--
Cheers
Ashok Pandey

icht...@yahoo.com

unread,
Oct 16, 2008, 4:45:58 AM10/16/08
to jBASE
You can very quickly create the prefix in the saved list with the
following command (hit <escape> in JED to get to the command line):

R9999//HELPTEXT.MENU>/

Regards,

Ryan

On Oct 15, 9:17 pm, "Ashok Pandey" <meas...@gmail.com> wrote:
> Ankit,
>
> if you give save list system will split the content in two parts with
> separator  '>'
>
> 1st part as a *file name* and 2nd part as a *record*. Hence your data are
> populated into file name field.
>
> *Probably you should do like this *

Harish Venugopal

unread,
Oct 16, 2008, 12:40:01 AM10/16/08
to jB...@googlegroups.com
Ankit,

Your savelist should contain the name of the file also and not only the record id. How in this world is the DL.DEFINE supposed to know, what the records relate to. To overcome this problem, you should have a savedlist which has the following format for each record in the list
 
 
For example, if you were to pack the contents of an enquiry say STMT.ENT.BOOK the savedlists should look something like this
 
jsh -> CT &SAVEDLISTS& MY.LIST
001 ENQUIRY>STMT.ENT.BOOK
002 STANDARD.SELECTION>NOFILE.STMT.ENT
003 GLOBUS.BP>E.STMT.ENQ.BY.CONCAT
 
Hope this clarrifies your queries on the usage of savedlists for preparing a DL.PACK
 
Rgds,
Harish
Skype : venugopal.harish

John Watson

unread,
Oct 16, 2008, 4:02:45 AM10/16/08
to jBASE
Or,

Create a new dictionary item in your file;

File DICT F.HELPTEXT.MENU , Record 'ID.DL' Insert
15:59:19
Command->
0001 I
0002 'HELPTEXT.MENU>':@ID
0003
0004
0005 45L
----------

then

jsh Modelbank ~ -->SELECT F.HELPTEXT.MENU SAVING ID.DL

317 Records selected

>SAVE.LIST DL.LIST
317 record(s) saved to list 'DL.LIST'


jsh Modelbank ~ -->EDIT.LIST DL.LIST
.jBASE.el.8
TOP
.
001 HELPTEXT.MENU>HEAD.TELLER
.
002 HELPTEXT.MENU>ACT
.
003 HELPTEXT.MENU>SCA.MENU
.
SELECT F.HELPTEXT.MENU SAVING ID.DL

ETC...

John.


Andrew Trusov

unread,
Oct 16, 2008, 1:23:19 AM10/16/08
to jB...@googlegroups.com
Hi!

You can try this

SELECT F.HELPTEXT.MENU SAVING EVAL '"HELPTEXT.MENU>":@ID'
SAVE-LIST DL.LIST

in that case you will get the list like this

HELPTEXT.MENU>AC.MENU
HELPTEXT.MENU>ACCOUNT.DESIGNER
HELPTEXT.MENU>ACCOUNT.DESIGNER.CARD
HELPTEXT.MENU>ACCOUNT.DESIGNER.CHARGE
...

without using Excel or text editor. And this is the exact type of list that suitable for DL.DEFINE


--
Andrew Trusov

HYTHAM MOUBARAK

unread,
Oct 16, 2008, 3:03:44 AM10/16/08
to jb...@googlegroups.com
HII

when u select u can use  EVAL to save your list as you want  ex
 
jsh bnk ~ -->SELECT @ID F.HELPTEXT.MAINMENU EVAL"'F.HELPTEXT.MAINMENU >':@ID"


 37 Records selected

>SAVE-LIST HELPTEXT.MAINMENU

THNX
 


Date: Wed, 15 Oct 2008 20:17:41 +0100
From: mea...@gmail.com
To: jB...@googlegroups.com
Subject: Re: T24: How to use Select list IN DL.DEFINE

anumanth

unread,
Oct 19, 2008, 4:24:56 AM10/19/08
to jBASE
Hi,

you can take save list like below and use it in DL.DEFINE

> JED &SAVEDLISTS& XXXX
>APPLICATION NAME WITH PREFIX > RECORDNAME

Here XXXX is your saved list name, you can give your standard name

Regards,

S.Anumanth

Ankit Patel

unread,
Oct 20, 2008, 1:11:48 PM10/20/08
to jB...@googlegroups.com
Hi All,

I used "R9999//HELPTEXT.MENU>/" and it worked fine. I just needed to know how to edit the saved list. Anyways, thank you all for helping me out.

Regards,
Ankit.

Reply all
Reply to author
Forward
0 new messages