Skip to main content

Hy i just saw in the d3 ref this:
https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/index_select_command.htm#reference4710

so i tryed
index-select sgvar016 A6(MCNA):" ":2
but i got the message
[162] Error in icode conversion: 'A6(MCNA):"'; index not found.

what is the correct way to use ?



------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------

Hy i just saw in the d3 ref this:
https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/index_select_command.htm#reference4710

so i tryed
index-select sgvar016 A6(MCNA):" ":2
but i got the message
[162] Error in icode conversion: 'A6(MCNA):"'; index not found.

what is the correct way to use ?



------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------

Hi Alberto,

I think the parser is getting it's knickers in a twist with the space in the A-correlative; so while a legal syntax; the command parser thinks the index.specification is A6(MCNA):"

If you are able, you could prove this by using a non-space in your index.specification A-correlative.

I guess what we need is a different command delimiter? Or the ability to specify via an A-correlative to append a space? I cannot think of one.

Source is available; and sure enough the routine is doing a space based field extract:

0026 Tclread tcl             
0027 tcl = Trim(tcl);* [03]  
0028 fn = Field(tcl," ",2)   

I guess you could copy this a routine of your own choosing and modify it, but it would then be a custom routine.



------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------

Hi Alberto,

I think the parser is getting it's knickers in a twist with the space in the A-correlative; so while a legal syntax; the command parser thinks the index.specification is A6(MCNA):"

If you are able, you could prove this by using a non-space in your index.specification A-correlative.

I guess what we need is a different command delimiter? Or the ability to specify via an A-correlative to append a space? I cannot think of one.

Source is available; and sure enough the routine is doing a space based field extract:

0026 Tclread tcl             
0027 tcl = Trim(tcl);* [03]  
0028 fn = Field(tcl," ",2)   

I guess you could copy this a routine of your own choosing and modify it, but it would then be a custom routine.



------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------

A guess a cheat-way would be to create a dictionary item that returns the space char; and use it as via the n(dictonaryitem) command:

Thus:

A6(MCNA):n(space)["1","1"]:2

Where 'space' is a dictionary item in the same file which always returns a single space.

That might work?



------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------

Hy i just saw in the d3 ref this:
https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/index_select_command.htm#reference4710

so i tryed
index-select sgvar016 A6(MCNA):" ":2
but i got the message
[162] Error in icode conversion: 'A6(MCNA):"'; index not found.

what is the correct way to use ?



------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------

i had some sucess but its not expect result yet

:up dict sgvar016 I.TEST
 
DICT sgvar016  'I.TEST' size = 32
01 S
02 6(MCNA):" ":2
INDEX-SELECT SGVAR016 I.TEST N 0986

where N is the direction 
0986 is the string i want to begin the search
but how to sow the results
expect result i want to see the string  created by the index  6(MCNA):" ":2


------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------

i had some sucess but its not expect result yet

:up dict sgvar016 I.TEST
 
DICT sgvar016  'I.TEST' size = 32
01 S
02 6(MCNA):" ":2
INDEX-SELECT SGVAR016 I.TEST N 0986

where N is the direction 
0986 is the string i want to begin the search
but how to sow the results
expect result i want to see the string  created by the index  6(MCNA):" ":2


------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------

Hi Again,

Not sure I understand your last.

If the routine works; it will create a select list of item keys from the file in question which has an index created with the nominated dictionary item or a-correlative.

I've not played with this; but wouldn't the index have to exist? Read the source of the routine to work out what it is doing.

The resulting select list would then be an active select-list and you can do what you want with those keys afterwards?

Am I missing your point?



------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------

Hi Again,

Not sure I understand your last.

If the routine works; it will create a select list of item keys from the file in question which has an index created with the nominated dictionary item or a-correlative.

I've not played with this; but wouldn't the index have to exist? Read the source of the routine to work out what it is doing.

The resulting select list would then be an active select-list and you can do what you want with those keys afterwards?

Am I missing your point?



------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------

Expect result:
DNI6913 00179
ACA017103 01850
6110502 00237
W2113STD 00116
63052RS 00162
2047CR 00510
0986332611 00035
ETE7814 00222
8PK1750HDGATES 02509
MOLHADEDOCENT 00493
CHCORRONDP17 01638
6106601 00237
W2114ST 00116

wich is A6(MCNA):" ":2

in QM i have the comand LIST.INDEX
for exemple:
LIST.INDEX sgvar016 i.test DETAIL
which show the stored strings for the index created
i liket to get the same result in D3



------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------

Expect result:
DNI6913 00179
ACA017103 01850
6110502 00237
W2113STD 00116
63052RS 00162
2047CR 00510
0986332611 00035
ETE7814 00222
8PK1750HDGATES 02509
MOLHADEDOCENT 00493
CHCORRONDP17 01638
6106601 00237
W2114ST 00116

wich is A6(MCNA):" ":2

in QM i have the comand LIST.INDEX
for exemple:
LIST.INDEX sgvar016 i.test DETAIL
which show the stored strings for the index created
i liket to get the same result in D3



------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------

Ahh, ok.

Stating the obvious: index-select doesn't do what QM's LIST.INDEX command does.

I've not used QM so I do not know if source is provided or not for commands; and of course I am choosing to ignore the whole copyright issue - but one way or another I suspect in d3 you will have to write your own routine to emulate/replicate LIST.INDEX

What does the documentation in QM say about LIST.INDEX and it's use?



------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------

Ahh, ok.

Stating the obvious: index-select doesn't do what QM's LIST.INDEX command does.

I've not used QM so I do not know if source is provided or not for commands; and of course I am choosing to ignore the whole copyright issue - but one way or another I suspect in d3 you will have to write your own routine to emulate/replicate LIST.INDEX

What does the documentation in QM say about LIST.INDEX and it's use?



------------------------------
David Knight
Senior Software Engineer
H3O Business Technologies Limited
------------------------------

hahah to much work
i was looking for an "easy" way...



------------------------------
Alberto Leal
System Analyst
Millano Distribuidora de Auto Pecas Ltda
Varzea Grande MT BR
------------------------------