Thursday, November 25, 2010

jBase Query Language I-DUMP / S-DUMP

Displays the entire contents of items in a file, including the system delimiters.

Command Syntax

I-DUMP file-specifier {record-list} {selection-criteria} {sort-criteria} {USING file-specifier} {(options}
Comments: Use the S-DUMP Command to produce sorted output.
Denoted as follows are system delimiters:

Attribute mark => ^
Value mark => ]
Sub value mark => \

Examples

jsh machinename ~ -->I-DUMP CUSTOMER WITH CUS.CITY ="BEAVERTON"
Generates the following output:
40840^Lexus of Portland^8840 Sw Canyon Rd.^Beaverton^OR^^503-297-9017^^^
40848^Kuni Cadillac & BMW^3725 SW Cedar Hills Blvd^Beaverton^OR^^503-643-1543^^
^
40855^Berg Car Company^10680 SW Canyon Rd.^Beaverton^OR^^503-641-1251^^^
40821^Beaverton Chrysler Plymouth^10760 SW Canyon Rd.^Beaverton^OR^^503-646-051
6^^^
jsh machinename ~ -->S-DUMP CUSTOMER BY CUS.ADDR WITH CUS.NAME "A..."
output as follows
40854^AA Auto Brokers^^^^^503-774-6701^^^
40813^Acura Of Portland^12560 SE Start^Portland^OR^98330^503 544 3032^503 544 3
958^^
40811^All Car Rental^1321 East 78th St, Suite 101^Bloomington^MN^55425^612 854
4045^612 851 9361^mglomb@acrental.com^
40873^Andy's Auto Supply & Repair^2150 SE Powell Blvd.^Portland^OR^^503-232-086
8^^^30058493^
40819^Alexander Chrysler-Plymouth^2340 NE Sandy Blvd.^Portland^OR^^503-233-4433
^^^

1 comments:

cp1 on August 13, 2012 at 9:48 AM said...

This isn't of much use as an occurence of the attribute mark, value mark or sub-value mark is not escaped in the output.

If a field has the value "This^breaks[every\thing" then it will break everything as the three mark characters are emitted un-escaped, so appear to be mark characters instead of unexceptional text.

Is there a way to escape the marks?

Post a Comment

 

Blog Info

A Pakistani Website by Originative Systems

Total Pageviews

Tutorial Jinni Copyright © 2015 WoodMag is Modified by Originative Systems