jql select and sort by numeric without using dictionary lookup

[Caleb Jeffery]

Hi 

Is it possible to do a jql LIST *a1 *a2 BY (*a2 FMT "20R") 

without using the dictionary lookup?

I find my self wanting to do cmd line sorted list sorting by an *A{n} attribute that always defaults to alphanumeric sort order however I would like to overwrite that sort order at cmd line instead of having to setup a dictionary item.

[Bruce Willmore]

LIST filename BY *a2 *a1 *a2 FMT “20R”

 

will do the trick.

--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Caleb Jeffery]

HI Bruce I Tried this solution but the sorting is not sorting based on Numeric Value

I am doin a LIST DICT filename BY *a2 *a2 FMT "3R"

No luck

Thanks for replying though 

To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscribe@googlegroups.com.

[pat]

You can create a file containing 'definitions' for Default Dictionary items

eg :

CREATE-FILE DATA DEFDICT 1

ED DEFDICT *A2

001 D

002 2

003

004 Attr 2

005 3R

export / set JBCDEFDICTS=DEFDICT

LIST DICT file BY *A2 *A2

should display in your expected [ Right Justified ] Sort order

Merry Christmas

[Caleb Jeffery]

Awesome this is exactly what i was after

[Clifford Ponce]

You could use an EVAL statement so no definition has to be created.

LIST DICT FILE BY EVAL "FMT(@RECORD<2>,'3R')" *A2