WDBASQL(*) TUTORIAL

==============================================================================================

WDBASQL(*) TUTORIAL

UNIT:1: Introduction

ABOUT WNOSQL DB

===============

WNOSQL means Wilmix NOSQL.(W*SQL) is a Securable database invented by wilmix jemin j in GDollar,JDollar(JWEB) ,and JAVA .

No need to write any Queries but to pass parameters in WDBASQL database for PLSQL f(x)s.

We can also write WDBASql queries like SQL/Oracle Queries.

WNOSQL is focused only on Windows Platform.

ADVANTAGES of Using WNOSQL in Windows Platform

A) To secure the data from hackers.

data cannot be taken by hackers in windows.

b) your .wdba data can be accessed from any location.

no need of datasource ; so we can say wnosql has remote database connection.

c) You can store 1 Thrillions of data using WNOSQL.

d) All .wdba data will be stored in a encrypted form that cannot be viewed by hackers.

What is meant by WNOSQL?

WNOSQL means Wilmix NOSQL.(W*SQL) . No need to write SQL Queries but to pass parameters in WNOSQL database functions.. WNOSQL is also transport data from Oracle db/SQLSERVER to WNOSQL and viceversa.

When it is invented?

It is invented by wilmix jemin j in year 2016.

Why WNOSQL is most important for software development?

Since it provides security , transports data from wnosql to Oracle,Sqlserver, and viceversa. And it will connect with major databases like Oracle,Sqlserver,MYSQL, etc. And it protect the hackers and unwanted users stealing the data.

How WNOSQL database Works?

WNOSQL database uses WNOSQL Editor. WNOSQL(.dlls) are responsible for

transporting , executing Query . WNOSQL did not contain server; Instead of that it contain only WebConsole to see the HTML outputs.

WNOSQL(W*SQL) takes the data from Sqlserver and store it.

We can also perform retrieval ,Encrypt,Decrypt data , Select particular row, Join Operations, Aggegerate tools,etc. using WNOSQL.

Which you can learn more detail in Unit -II.

let us see how it works? Why it is more advanced?

Explanation:

============

When Users type WNOSQL(W*SQL) Program at first you compile the db program using compile at right corner of the editor.

And Next you run the program using Run at right corner of the editor.

When you click "RUN" it produces .obj and .exe file for futhure use with CDollar, JAVA, Dotnet, and JDollar, JSAUCER, etc. So You can selected only encrypted (.obj) file and run the database program.SO choose the .dll file to run wnosql program

.When you insert a data in a program it stores it in WNOSQL

encrypted file and finally it retrieves the data from encrypted file for futhure use. WNOSQL is responsible for data security with data storage and retrieval management.You can also do programmming simillar to PLSQL and wecan change the theme of HTML Output. You can see the output in webconsole by pressing RUNWNOSQL(*) button at the right corner of WNOSQL(*) Editor.

State the Advantages of WNOSQL (*) Database:

=============================================

a) WNOSQL(*) is a NOSQL databases

b) WNOSQL(*) need no datasource since it remotely connect with CDollar or JDollar Program

c) WNOSQL also has SQL Concepts and SQL Advanced concepts

d) You can see the output the WEB console there is no need for server

e) WNOSQL uses cluster memmory management to protect your data from hackers ,etc.

f) WNOSQL will Store Huge amount of data ie ) > Thrillion Thrillion …….

g) WNOSQL(*) has Userfriendly WNOSQL cmd console

h) WNOSQL Prevents SQL INJECTION

i) WNOSQL(*) has attractive syntax.

j) WNOSQL(*) also has PLSQL to execute db statements as a batch.

k) WNOSQL(*) also has Advanced oops like JAVA and C#

l) WNOSQL is a Advanced Database.

m) WNOSQL also transfer to and from Oracle/SQLSERVER/MYSQL to WNOSQL Database; so it is called PIPELINE DATABASE.

n) We can also use CDollar dlls with WNOSQL

o) WNOSQL also store the output in .EXE format

p) WNOSQL also be used with other Programming languages through through Oracle/SQL Server.

q) WNOSQL PLSQL uses API format which hacker or unwanted user can' use it in website.

r) We can use WNOSQL (.wdba) data for futhure use with remote database WDBAJ$ at any linux type OS.

s) It is easy to use and Learnable

t) We can also do programming in WNOSQL database

u) We can also construct forms and reports

v) Here CDollar-JAVA.util packages are used

w) No Server for WNOSQL(*) db

x) Occupies only less amount of safe

y) Prevents from data loss by CLUSTERRESTORE

z) Performs Manipulations (WNOSQL(*) ) in huge amount of data say 1 thrillion.

never makes db very slow since datas are divided into batches.

=============================================

UNIT-2:The WNOSQL SQL(*) BASICS

===============================

1) CREATETABLE

CREATETABLE from Tablename index1 to lastindex1 , row to cols ?= 0 By 0 f(x) :

{FIELDSNAMES}:{Fieldvaluesset1 , Fieldvaluesset2 } :{0};

Explanation

CREATETABLE from Tablename which is used to create a table by given rows and cols with Tablefields and Table field value....

2) SelectRowVAL

SELECTRVAL from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0}

:{0}

Explanation

SELECTRVAL is used to list all values from Tablename by given rows and cols.

3) DELETE

DELETE from Tablename index1 to lastindex1 , row to col ?= Character By X X : {value} :

{0} :{0}

Explanation

DELETE is used to delete a particular value from a table by given rows and cols.

4) SYSDATE

SYSDATE from Tablename index1 to lastindex1 , row to col ?= DATEFORMAT By X X : {0} :

{0} :{0}

Explanation

It is used to return SYSTEM DATE [according to DATEFORMAT- Optional]

5) INSERTINTO STATEMENT

INSERTINTO from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} :

{rowsetvalues1-- rowsetvaluesn} : {0}";

Explanation

It is used to insert rowset values from Tablename by given rows and cols.

6) MATCH STATEMENT

MATCH from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :{0}

Explanation:

IT is used to list row pairs where the given Character is matched from Tablename by given rows and cols.

7) SelectOrderbyAsc

SelectOrderByASC from index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :{0}

Explanation:

IT is used to list the values by Ascending order from Tablename by given rows and cols.

8) SelectOrderbyDesc

SelectOrderByDESC from index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :{0}

Explanation:

IT is used to list the values by Descending order from Tablename by given rows and cols.

9) SelectIntOrderByAsc

SelectOrderByASC from index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :{0}

Explanation:

IT is used to list the values by Ascending order from Tablename by given rows and cols.

10) SelectIntOrderByDesc

SelectOrderByDESC from index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :{0}

Explanation:

IT is used to list the values by Descending order from Tablename by given rows and cols.

11) SelectALL Statement

SelectAll from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :{0}

Explanation

SelectAll is used to list all values from Tablename by given rows and cols.

but SelectRval is used to compute the size of ArrayList.

12) Select Statement

Select from Tablename index1 to searchselectindex , row to col ?= Character By X X : {0} : {0}

:{0}

Explanation

Select is used to list a particular value using searchselectindex from Tablename by given rows and cols.

13) Search Statement

Search from Tablename index1 to indexn , row to col ?= Character By X X : {0} : {0} :{0}

Explanation

=======

Search is used to list a arraylist value when given Character or a number is found f rom Tablename by given rows and cols.

14) SearchGT Statement

SearchGT from Tablename index1 to indexn , row to col ?= Searchednumber By X X : {0} : {0}

:{0}

Explanation

SearchGT is used to list the values which is greater than a Searchednumber from the Tablename by given rows and cols.

15) SearchLS Statement

SearchLS from Tablename index1 to indexn , row to col ?= Searchednumber By X X : {0} : {0}

:{0}

Explanation

SearchLS is used to list the values which is less than a Searchednumber from the Tablename by given rows and cols.

16) SelectRange Statement

SelectRange from Tablename indexrange1 to indexrangen , row to col ?= Char By X X : {0} :

{0} :{0}

Explanation

SelectRange is used to list the values according to given indexranges( indexrange1 to indexrangen ) from the Tablename by given rows and cols.

17) SelectAssign Statement

SelectAssign from Tablename indexrange1 to indexrangen , row to col ?= ASSIGNEDVALUE By X X : {0} : {0} :{0}

Explanation

SelectAssign is used to Assign the values

18) SelectRows Statement

SelectRows from Tablename x1 to x2 , row to col ?= X By X X : {0} : {0} :{0}

Explanation

SelectRows is used to list the Assigned Row value

19) RIGHTJOIN Statement

RIGHTJOIN from Tablename1 x1 to x2 , row to col ?= Tablename2 By 1 1 : {rowindexes}

:{rowindexes} : {0} ;

Explanation:

It is used to print Right Table of the SQL TABLE PLUS those rows of Lefttable did not match with rows of Right table.

20) LEFTJOIN Statement

LEFTJOIN from Tablename1 x1 to x2 , row to col ?= Tablename2 By 1 1 : {rowindexes}

:{rowindexes} : {0} ;

Explanation:

It is used to print LEFT Table of the SQL TABLE PLUS those rows of Lefttable did not match with rows of RIGHT table.

21) INNERJOIN Statement

INNERJOIN from Tablename1 x1 to x2 , row to col ?= Tablename2 By 1 1 : {rowindexes}

:{rowindexes} : {0} ;

Explanation:

InnerJoin means the intersection between two tables. ie) the common rows.

22) SelectIN Statement

SelectIN from Tablename1 x1 to x2 , row to col ?= MEMBERDATA By 1 1 : {0} :{0} : {0} ;

Explanation:

========

SelectIn data is used to test whether the given member data is found or not then print that data.

23) SelectNOTIN Statement

SelectNOTIN from Tablename1 x1 to x2 , row to col ?= MEMBERDATA By 1 1 : {0} :{0} : {0} ;

Explanation:

SelectIn data is used to test whether the given member data is found or not then print that data.

24) Count(*)

Count(*) from Tablename1 x1 to x2 , row to col ?= X By 1 1 : {0} :{0} : {0} ;

Explanation:

It is used to list no of rows in table tablename1. not then print that data.

24) ENCRYPT

Encrypt from Tablename1 x1 to x2 , row to col ?= X By 1 1 : {0} :{0} : {0} ;

Explanation:

It is used to Encrypt a table tablename1.

25) DECRYPT

Decrypt from Tablename1 x1 to x2 , row to col ?= X By 1 1 : {0} :{0} : {0} ;

Explanation:

It is used to Decrypt a table tablename1.

26) SelectCols

SelectCols from Tablename1 x1 to x2 , row to col ?= X By 1 1 : {column indexes} :{0} : {0} ;

Explanation

It is used to list the column values according to column indexes.

27) Distinct

DISTINCT from Tablename1 x1 to x2 , row to col ?= X By 1 1 : {column indexes} :{0} : {0} ;

Explanation

It is used to remove duplicate column values according to column indexes.

28) INSERT STATEMENT

Insert from Tablename index1 to lastindex1 , row to col ?= Character By X X : {rowsetvalues1-- rowsetvaluesn} : {0} : {0}";

Explanation

It is used to insert rowset values from Tablename by given rows and cols.

29) SelectUPPER Statement

SelectUPPER from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :

{0}";

Explanation

It is used to list the values from TableName in Uppercase by given rows and cols.

30) SelectLOWER Statement

SelectLOWER from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :

{0}";

Explanation

It is used to list the values from TableName in Lowercase by given rows and cols.

31) PRIMARYKEY

PrimaryKey from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :

{0};

Explanation

It is used to remove the Duplicate values or print unique values from TableName by given rows and cols.

32) InsertDESC

InsertDESC from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :

{0};

Explanation:

It is used to insert table describtion

32) SelectDESC

SelectDESC from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} :

{0};

Explanation:

It is used to list about table description.

33) SelectC*

SelectC* from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} : {0}; Explanation

It is used to Count no of columns present in the table

33) SelectR*

SelectR* from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} : {0} : {0}; Explanation

To compute howmany rows in field table use SELECTR* and display it in table format

34) <HAVING> Clause

It is used to perform aggregate f(x) to column and in condition (eg) (SUM)(fields) >

0 and combine the join results ..

35) UPDATE STATEMENT

UPDATE from Tablename index1 to lastindex1 , row to col ?= X By 1 1 : {value1} :{value2}:{0} Explanation

It is used to Update value1 to value2 from Tablename by given rows and cols.

36 ) SelectLike Statement

SelectLike from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} :{0}:{0} Explanation:

Display all names with middle name , last, firstname

37) LOC Statement

Loc is used to find the given data stored in a location in a table.

SYNTAX:

LOC from Tablename index1 to lastindex1 , row to col ?= Character By X X : {0} :{0}:{0}

38) AVG()

AVG() from Tablename index1 to lastindex1 , row to col ?= X By X X : {numbervalues} :{0}:{0}

Explanation:

It is used to compute Avg of given values...

39) MAX()

MAX() from Tablename index1 to lastindex1 , row to col ?= X By X X : {numbervalues} :{0}:{0}

Explanation:

It is used to compute MAX of given values...

40) MIN()

MIN() from Tablename index1 to lastindex1 , row to col ?= X By X X : {numbervalues} :{0}:{0}

Explanation:

It is used to compute MIN of given values...

41) SUM()

SUM() from Tablename index1 to lastindex1 , row to col ?= X By X X : {numbervalues} :{0}:{0}

Explanation:

It is used to compute SUM of given values...

42) DATACOMPARE (ASC/DESC)

================================

DateCompareDESC from DATES index1 to index2 , rows to cols ?= X By XX : {Indexvalues}

:{0}:{0};

ii)

DateCompareASC from DATES index1 to index2 , rows to cols ?= X By XX : {Indexvalues}

:{0}:{0};

This statements i) and ii) is used to List Dates in Ascending or Descending order according to IndexValues.

43) CLUSTER DEMOS

======================

a) CLUSTER:

CLUSTER from index1 to index2 , rows to cols ?= x By x f(x) : {DATAVALUES}: {0} :{0}

Explanation:

To Store CLUSTER of Data form a given range in a encrypted and retrieve from encrypted file...

b) CLUSTERPROPERTY

CLUSTERPROPERTY from index1 to index2 , rows to cols ?= x By x f(x) : {DATAVALUES}: {0} :{0}; Explanation

To compute clustertable size, display data, display system date, Display remaning space available to store values in a cluster table.

c) BACKUPCLUSTER :

BACKUPCLUSTER from index1 to index2 , rows to cols ?= x By x f(x) :{DATAVALUES}: {0} :{0};

Explanation

============

TO RESTORE the Lost CLUSTER DATA and automatically store the contents in a table.

What are the Things Needed to execute the Query?

Step-1:

String g = WDBASQL.WDBASQLS("databasename", "USEDATABASE", "dbpasswordtablename", "pathwhereserverdataisstored");

Step-2:

String t = WDBASQL.WDBASQLS("dbusertable", "dbpwdtable", 1, "username", "password", 1, 5, g);

Step-3:

char c=' ';

String query ="WNOSQL DB STATEMENTS";

Step-4:

WDBA.writeln(""+WDBALIB.WDBAQUERY( query, t));

=================================================================

UNIT:3- WNOSQL(PLSQL*) Basics

===============================================================

The WNOSQL PLSQL statements

============================

The WnoSql statements which is listed which are given below. Insert => Insert values into the table and create a new table eg-1)

WDBASQL.Query("Insert","table" ,"",values,0,"","", null,"",0," ","",c,null,t,rows,cols);

WDBA.writeln((manipulate.Signal("MANIPULATE","Select query"

,"tablename","column1,column2,...","?,?...",rows+1,"Drivers","datasource","username","password ",

"newencrytedtable")));

Select All => Select all rows from the table from a given range eg)

WDBASQL.Query("SelectAll","tablename" ,range1,null,range2,"","", null,"",0," ","",c,null,t,rows,cols);

Select => Select a particular column (key) values from a table WDBASQL.Query("Select","tablename" ,range1,null,key,"","", null,"",0," ","",c,null,t,rows,cols);

DateCompare => It is used to compare dates

WDBA.writeln("value="+WDBASQL.Query("DateCompare","datetable"

,"datetable2",null,noofcolumns,"datetable2",pwd, null,"",0," ","",c,null,t,rows,cols));

DateCompareAsc => it is used to compare dates and sort the date in ASC

WDBA.writeln("value="+WDBASQL.Query("DateCompareASC","datetable"

,"datetable2",null,noofcolumns,"datetable2",pwd, null,"",0," ","",c,null,t,rows,cols));

SelectRange => It is used to select column values with in a range

WDBA.writeln("value="+WDBASQL.Query("SelectRange","tablename"

,"datarange1",null,noofcolumns,"datarange2",pwd, null,"",0," ","",c,null,t,rows,cols));

Search => Search a data with in a table

WDBA.writeln("value="+WDBASQL.Query("Search","tablename" ,"0",null,totalrows,"data",pwd, null,"",0," ","",c,null,t,rows,cols));

SearchGT => Search data which is greater than a given data

WDBA.writeln("value1="+WDBASQL.Query("SearchGT","tablename" ,"0",null,totalrows,"data",pwd, null,"",0," ","",c,null,t,rows,cols));

SearchLS =>Search data which is lesser than a given data

WDBA.writeln("value2="+WDBASQL.Query("SearchLS","tablename" ,"0",null,totalrows,"data",pwd, null,"",0," ","",c,null,t,rows,cols));

AVG => it is used to compute the avg of the given datas

WDBASQL.Query("AVG","tablename" ,"",null,noofcols,"","", null,"",0," ","",c,null,t,rows,cols);

MAX => it is used to find the max of the given datas

WDBASQL.Query("MAX","tablename" ,"",null,noofcols,"","", null,"",0," ","",c,null,t,rows,cols);

MIN=> it is used to find the max of the given datas

WDBASQL.Query("MIN","tablename" ,"",null,noofcols,"","", null,"",0," ","",c,null,t,rows,cols);

DSerialize=> it is used to deserialize and retrieve the data WDBASQL.Query("DSerialize","wilmix" ,"","",0,"",pwd, null,"",0," ","",c,null,t,rows,cols); Update => Insert a value into table but the last columns values be deleted

WDBASQL.Query("Update","tablename" ,"datatobeupdated",null,nooforows,"newdata",pwd, null,"",0," ","",c,null,t,rows,cols);

Delete => Delete a particular data or delete all the datas

WDBASQL.Query("Delete","tablename" ,"datatobeupdated",null,nooforows,"newdata",pwd, null,"",0," ","",c,null,t,rows,cols);

InsertDB => Store the data in WDBA file

WDBASQL.Query("INSERTDB","tablename" ,"",String,0,"",pwd, null,"",0," ","",c,null,t,rows,cols);

SelectIntOrderByAsc => Sort all Int data in Table by Ascending order

WDBASQL.Query("SelectIntOrderByAsc",tablename,startindex

,null,endingindex,"123","",null,"",0,"","",char,null,password,row,cols);

SelectIntOrderByDesc => Sort all Int data in Table by Descending order

WDBASQL.Query("SelectIntOrderByDesc",tablename,startindex

,null,endingindex,"123","",null,"",0,"","",char,null,password,row,cols);

SelectOrderByAsc => Sort all data in Table by Ascending order

WDBASQL.Query("SelectOrderByASC",tablename,startindex

,null,endingindex,"123","",null,"",0,"","",char,null,password,row,cols);

SelectIntOrderByDESC => Sort all data in Table by Ascending order

WDBASQL.Query("SelectOrderByDESC",tablename,startindex

,null,endingindex,"123","",null,"",0,"","",char,null,password,row,cols); Insert => Insert the values from arraylist to the tablename

WDBASQL.Query("Insert",tablename ,"",arraylist,0,"","", null,"",0," ","",char,null,password,row,cols);

SelectIN => Display or check whether the member is present in the table. WDBASQL.Query("SelectIN",tablename

,startindex,null,endingindex,data,"",null,"",0,"","",char,null,password,row,cols); SelectNOTIN => Display all member is present in the table.

WDBASQL.Query("SelectNOTIN",tablename

,startindex,null,endingindex,data,"",null,"",0,"","",char,null,password,row,cols);

SelectLike => Display all names with middle name , last, firstname WDBASQL.Query("SelectLike",tablename

,startindex,null,endingindex,"","",null,"",0,"","",char,null,password,row,cols);

Count(*) => to count no of rows in the table

WDBASQL.Query("Count(*)",tablename ,"0",null,0,"","",null,"",0,"","",c,null,password,row,cols);

MATH => Apply mathematical functions in a table WDBASQL.Query("MATH",tablename

,"0",null,0,"0","",null,"",0,"",function,c,null,password,row,cols);

Encrypt => Encrypt the table

WDBASQL.Query("Encrypt",tablename ,"0",null,0,"5","",null,"",0,"","",c,null,password,row,cols);

Dencrypt => Dencrypt the table

WDBASQL.Query("Dencrypt",tablename ,"0",null,12- 3,"5","",null,"",0,"","",c,null,password,row,cols);

Droptable => Drop the table

WDBASQL.Query("DropTable",tablename ,"0",null,0,"0","",null,"",0,"","",c,null,password,row,cols);

INSERTINTO => Insert Arraylist into tablename

WDBASQL.Query("INSERTINTO",tablename

,startindex,null,endingindex,"","",ARRAYLISTINSERTION,"",0,"","",c,null,password,row,cols);

DeleteAll=> Delete All the contents from table

WDBASQL.Query("DeleteAll",tablename ,"0",null,0,"","",null,"",0,"","",c,null,password,row,cols);

AVG=> AVG of nos from table WDBASQL.Query("AVG()",tablename

,startindex,null,endingindex,"","",ARRAYLISTINSERTION,"",0,"","",c,null,password,row,cols);

MAX=> MAX of nos from table

WDBASQL.Query("MAX()",tablename

,startindex,null,endingindex,"","",ARRAYLISTINSERTION,"",0,"","",c,null,password,row,cols); MIN=> MIN of nos from table

WDBASQL.Query("MIN()",tablename

,startindex,null,endingindex,"","",ARRAYLISTINSERTION,"",0,"","",c,null,password,row,cols);

MAX=>SelectColumns between range startingindex and endingindex depends upon the the given arryalist values from table

WDBASQL.Query("SelectCols",tablename,startindex,null,endingindex,"0","",ARRAYLISTINSERTION

,"",0,"","",c,null,password,row,cols);

Count() => to count the occurance of data with in a given range startingindex and endingindex from the table.

WDBASQL.Query("Count()",tablename

,startindex,null,endingindex,data,"",null,"",0,"","",c,null,password,row,cols);

DISTINCT => is used to remove duplicates from the table

WDBASQL.Query("DISTINCT",tablename ,startindex,null,endingindex,"","", ARRAYLISTINSERTION,"",0,"11","",c,null,password,row,cols);

SUM() => To find the sum of nos in a given Arraylist column indexes.

WDBASQL.Query("SUM()",tablename

,null,null,null,"","",ARRAYLISTINSERTION,"",0,"","",c,null,password,row,cols);

LOC() => is used to find the given data stored in a location in a table.

WDBASQL.Query("LOC()",tablename

,startindex,null,endingindex,data,"",null,"",0,"","",c,null,password,row,cols);

MATCH() => to get match columns locations in a arraylsit of values with in a range matching the given data

WDBASQL.Query("MATCH",tablename

,startindex,null,endingindex,data,"",null,"",0,"","",c,null,password,row,cols);

DateCompareDESC => To sort the given dates present in a table by ascending order.

WDBASQL.Query("DateCompareDESC",tablename

,startindex,null,endingindex,"","",ARRAYLISTINSERTION,"",0,"","",c,null,password,row,cols);

DateCompareDESC => To sort the given dates present in a table by Decending order.

WDBASQL.Query("DateCompareASC",tablename

,startindex,null,endingindex,"","",ARRAYLISTINSERTION,"",0,"","",c,null,password,row,cols); INNERJOIN => Join two table based on the matching column values

WDBASQL.Query("INNERJOIN",tablename1,"0",null,0,tablename2,"",ARRAYLISTINSERTION1,"",0,"",

"",c,ARRAYLISTINSERTION2,password,row,cols);

InsertDesc = > Create table fields

WDBASQL.Query("InsertDESC", tablename, "0", ARRAYLISTINSERTION, 0, "", "", null, "", 0, "", "", c,

null,password,row,cols);

INSETINTO = > Used to insert a arraylist collection values in the table this is mostly used for insertion.

WDBASQL.Query("INSERTINTO", tablename, "0",null, arraylistsize(),"0","",null,"",0,"","",c,ARRAYLISTINSERTION2,password,row,cols); SELECTRVAL =>Selectall values from rows in a table and compute the size.

WDBASQL.Query("SELECTRVAL",tablename, "0", null, 0, "0", "", null, "", 0, "", "",

c,null,password,row,cols);

LEFTJOIN => The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.

WDBASQL.Query("LEFTJOIN",tablename1,"0",null,0,tablename1,"", ARRAYLISTINSERTION1,"",0,"","",c,ARRAYLISTINSERTION2,password,row,cols);

RIGHTJOIN =>The RIGHT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.

WDBASQL.Query("RIGHTJOIN",tablename1,"0",null,0,tablename1,"", ARRAYLISTINSERTION1,"",0,"","",c,ARRAYLISTINSERTION2,password,row,cols);

AND => is used to combine two results of Query and put them into arraylist for futhure use.

WDBASQL.Query("AND", "", startindex,null,endingindex, "", "", ARRAYLISTINSERTION1, "", 0, "", "", c,ARRAYLISTINSERTION2,password,row,cols);

Foreignkey => It is used to set Foreign key between startindex and endingindex of the table ; but it will also accept null and duplicate values.

WDBASQL.Query("ForeignKey",tablename1, startindex,null,endingindex, "", "", null, "", 0, "", "", c, null,password,row,cols);

HAVING => it is used to perform aggregate f(x) to column and in condition (eg) (SUM)(fields) > 0 and combine the join results ..

WDBASQL.Query("<HAVING>",tablename1, startindex,null,endingindex,"[col1,col3..],[col1,col3..]","",ARRAYLISTINSERTION1,"",0,"","", c,ARRAYLISTINSERTION2,password,row,cols);

To compute howmany rows in field table use SELECTR* and display it in table format WDBASQL.Query("SELECTR*",tablename ,"0",null,0,"0","",null,"",0,"","",c, null,password,row,cols); Select all Row values for given Row list value use SELECTROWS for the given range

WDBASQL.Query("SELECTROWS",tablename ,"0",null,0,"0","",null,"",0,"","",c, null,password,row,cols);

Select all Column values for given column list Indexed value use SELECTCOLUMNS for the given range

WDBASQL.Query("SELECTCOLUMNS",tablename ,"0",null,0,data,"",INSERTIONARRAYLIST,"",0,"","",

c, null,password,row,cols);

Select all Row values for given row list value based on indexes for given range and increment the counter based on counter value

WDBASQL.Query("SELECTINDEXES",tablename ,"0",null,0,data,"",INSERTIONARRAYLIST,"",0,"","",c

, null,password,row,cols);

Encode String to numbers WDBASQL.Query("SelectAssign",tablename1,

assignindex,null,endingindex,"1","",null,INSERTIONDATALIST,0,"","",c, null,password,row,cols);

InsertValues into the table WDBASQL.Query("InsertValues",tablename1,

startindex,null,endingindex,"","",null,INSERTIONDATAARRAYSTRINGLIST,0,"","INSERT1",c, null,password,row,cols);

To Count no of columns present in the table

WDBASQL.Query("SELECTC*",tablename ,"0",null,0,"0","",null,"",0,"","",c, null,password,0,1);

Select particular column value from the table

WDBASQL.Query("Select",tablename ,"0",null,endingindex,"0","",null,"",0,"","",c, null,password,0,1);

PrimaryKey => it is used to remove duplicates and null values

WDBASQL.Query("PrimaryKey",tablename1, startindex,null,endingindex, tablename1, "", null, "", 0, "", "", c, null,password,row,cols);

SelectUPPER => Select all the values in a given range from table and convert to upper case.

WDBASQL.Query("SelectUPPER",tablename , startindex,null,endingindex,"","",INSERTIONARRAYLIST,"",0,"","",c, null,password,row,cols);

SelectLOWER => Select all the values in a given range from table and convert to upper case.

WDBASQL.Query("SelectLOWER",tablename , startindex,null,endingindex,"","",INSERTIONARRAYLIST,"",0,"","",c, null,password,row,cols);

To display system date and time

WDBASQL.Query("SYSDATE","" ,"",null,0,"","",null,"",0,"","",c, null,password,row,cols); To display dateandtime in a format given

WDBASQL.Query("ManipulateDate()","" , startindex,null,endingindex,"","",INSERTIONARRAYLIST,"",0,dateformatstring,"",c, null,password,row,cols);

To Store CLUSTER of Data form a

given range in a encrypted and retrieve from encrypter file...

WDBASQL.Query("CLUSTER",tablename , startindex,null,endingindex,"","", INSERTIONARRAYLIST,"",0," ","",c, null,password,row,cols);

TO RESTORE the Lost CLUSTER DATA and automatically store the contents in a table.

WDBASQL.Query("BACKUPCLUSTER",tablename ,startindex,null,endingindex,"","", null,"",0," ","",c, null,password,row,cols);

To compute clustertable size, display data, display system date, Display remaning space available to store values in a cluster table.

WDBASQL.Query("CLUSTERPROPERTY",tablename ,startindex,null,endingindex,"","", null,"",0," ","",c, null,password,row,cols).get(row,cols);

To convert date to calendar

DatetoCalendar() => Inputstring(fx,data)

To convert date to String

DatetoString() =>Inputstring(f(x) ,data)

To convert calendar to date

CalendartoDate()=>

To return dateand time in a given format for the columns (0-year, 1-month,2-year)=> Specify this in arraylist.

getCalender() => Inputstring(f(x),columns)

To convert String to date

StringtoDate()=> Inputstring(f(x) ,data)

To search a data with in a given range Search=> Inputstring(data,i111,key)

To set triggers and allias for the table. InsertAllias,InsertTriggers =>Inputstring( obj)

To select all the Allias from the table SelectAllias =>Inputstring(cmd,key)

To check whether given data is greater than or less than from the range of values from the table.

SearchGT,SearchLS => Inputstring(i111,key,cmd)

To select all the Triggers from the table

SelectTriggers => Inputstring(cmd,key)

To select all the columns or field names from the table.

SelectDESC => Inputstring(0 to key)

To Serialize or Deserialize a table.

DSerialize,Serialize()=> Inputstring(cmd)

To select all the range values from the table SelectRange()=>Inputstring(i111 to key)

To Delete all the contents form the table. DeleteAll => Inputstring(cmd)

To Delete a range from a table

WDBASQL.Query("DELETE", "tablename", "0", null, 0, "0", "", columns, "", 0, "", "", c, null, password, rows, cols);

To Recall the values stored in the file and convert to table format.

RECALL => Inputstring(cmd)

To Insert values in .wdba file and retrieve it...

INSERTDB => Inputstring(cmd)

To create an empty table with fields

WDBASQL.Query("CREATETABLE", "tablename", "0", null, 0, "0", "", arraylisttablename, "", 0, "", "", c, arraylistintialvalues, t, rows,cols);

TO insert values into batch table.

WDBASQL.Query("INSERTBATCHTABLE", "tablename", "0", null, 0, "0", "", arraylisttablenames, "", 0, "", "", c, arraylisttablevalues, t, rows,cols);

To insert password into password table

WDBASQL.Query("Password", "tablename", "0",passwordarraylist, 0, "0", "", null, "", 0, "", "", c, null, t, rows,cols);

To insert username into username table

WDBASQL.Query("Username", "tablename", "0",usernamearraylist, 0, "0", "", null, "", 0, "", "", c, null, t, rows,cols);

a) CREDENTIALS methods and how you create a database ?

String g=WDBASQL.WDBASQLS("datastorehgh","USEDATABASE", "wilmix","C:\\Programs\\WNOSQL\\WNOSQLProgramfiles\\WNOSQL");

String t= WDBASQL.WDBASQLS("loginuser","pwduser",1,"Wilmix", "Wilmixjemin12345",1,5,g);

ArrayList ar788=WDBASQL.Query("Password", "dbpwds", "0",ar9s, 0, "0", "", null, "", 0, "", "", c, null, t, 1,5);

ArrayList ar788=WDBASQL.Query("Username", "dbuser", "0",ar9s, 0, "0", "", null, "", 0, "", "", c, null, t, 1,5);

default will be "Username" for username and pwd for password

i) COMMIT for dropping the table

WDBASQL.Query("commit", tablename, "0", null, 0, "", "", null, "", 0, "", "", char, null, pasword, rows, cols);

j) CLUSTER to store group of data in a encrypted form for futhure use.

WDBASQL.Query("CLUSTER",tablename ,rangestart,null,rangeend,"","", arraylistdata,"",0," ","",char, null, pasword, rows, cols);

Most Important Method API for WNOSQL PLSQL ODBCDRIVER

========================================================

public static ArrayList deserialize(String line, String cmd,String i111,Object obj,int key, String data,ArrayList columns,String values,int sheetno,String fx,String sname,char c2,ArrayList columns1,int rc , int cc)

line =>command

cmd => table

i111=> startingrange

obj => To pass any datatype

key => endingrange

data=> data to be searched or manipulated

Columns => table1 columns indexed values to be manipulated

values => Insert values

int sheetno=> sheetno (default must be 0)

String fx=> mainly used for math functions

String sname => Sheetname

char c2=> Mostly used in character occurance testing

ArrayList columns1=>table1 columns indexed values to be manipulated

int rc => rows

int cc=> cols

Note: You can use this api to pass the Inputstring parameters

WDBASQL.QUERY(????)

How WNOSQL DB store and retrieve the data? how it restore the data ?

=================================================================

WNOSQL stores the data in the form of cluster. Every database file .wdba has .cluster file and

WNOSQL database .wdba

contents is first passed to cluster datastructure and such data is

stored in a cluster form and cluster encrypted form by using CLUSTER QUERY.

CLUSTERSTORE will retrieve the contents and put the contents again in .wdba file for futhure use.

If you lost all the data no need to worry about it.

just pass BACKUPCLUSTER with clustername in WNOSQLQUERY..

.wdba and cluster files with datas are restored from cluster encrypted file.

so don't delete cluster encrypted files in c:/Program/WNOSQL...

==============================================================================================

UNIT-4:WNOSQL(WSQL*) Forms and Reports

=================================================================

WNOSQL(WSQL*) Forms and Reports

WDBA.writeln("html tags"); HTML.displayhtml("html file");

<TRY> => try block

<CATCH> => Catch block in wnosql

<EXE> => Exception

SYNTAX:

=======

<PACK>

<DATALIB> namespacename

<DATA>

public <CLASS> classname

{

public void main()

{

<!WNOSQL Statements !>

}

</DATA>

EXAMPLE:

========

<PACK>

<DATALIB> namespacename

<DATA>

public class WDBALogin --> <Serialize>

{

public void main( ) throws <EXE> // main program with throw //Exception

{

<TRY>

{

WDBA.writeln("<html><head><title>WDBA LOGIN</title> </head>");

WDBA.writeln("<body class=fancy>");

WDBA.writeln("<form action=http://localhost:5000/view1.WNOSQL method=post >");

WDBA.writeln("<div id=pageContainer>");

WDBA.writeln("<div id=pageContent>");

WDBA.writeln("<div id=chaptersAccordion>");

WDBA.writeln("<h2><a href=#chapter1>Enter your System Details</a></h2>"); WDBA.writeln("<div>");

WDBA.writeln("<p>Enter your Username : <input type=text name=uname size=15/></p>"); WDBA.writeln("<p>Enter the password : <input type=password name=password size=25

/></p>");

WDBA.writeln("<p>Enter the TABLE NAME : <input type=password name=table11 size=25

/></p>");

WDBA.writeln("<p>Enter the system password : <input type=password name=spwd size=25

/></p></div>");

WDBA.writeln("<div><input type=submit name=Click><input type=reset name=Clear></div>");

WDBA.writeln("</form></body></html>");

}

<CATCH>(<EXE> e){}

}

</DATA>

</WNOSQL>

Explanation:

============

All WNOSQL program should begin with <WNOSQL> and <PACK> is used to import utilities packages like arraylist , linked lsit etc.

And <DATALIB> is namespace for WNOSQL.

and <DATA> represents the Logic of WNOSQL oops plsql logic.

WDBA.Writeln => to print the string in webconsole

HTML.displayhtml("htmlfile")=> it is used to display html forms and reports.

================================================================

UNIT -5 :WNOSQL (WSQL*) interaction with native databases

=================================================================

For Oracle Server

===================

WDBA.writeln(""+manipulate.Signal("MANIPULATE","Select * from student","student","sno,tmar k,rank","?,?,?",4,"oracle.jdbc.driver.OracleDriver","jdbc:oracle:thin:@localhost:1521:xe","system", "jemin","wilmix2"));

FOR SQL SERVER

================

WDBA.writeln(""+manipulate.Signal("MANIPULATE","Select * from student","student","sno,tmar k,rank","?,?,?",4,"sun.jdbc.Odbc.JdbcOdbcDriver","jdbc:odbc:sa","system","jemin","wilmix2"));

FOR MYSQL

========

Use MYSQL database driver instead of sun.jdbc.Odbc.JdbcOdbcDriver.

note: select the following dll which is given below

manipulate.dll , ikvm.open.jdbc.dll to compile this WNOSQL plsql program.

=================================================================

UNIT-6: WNOSQL(*) Test Exercises

================================================================================================

WNOSQL(*) Test Exercises

=======================

1) Write a WNOSQL Program to select all students from a student table?

<PACK>

<USE> CDollar.WDBA; //load wnosql packages

<DATALIB> ps

<DATA>

public <CLASS> SQL3

{

public void main()

{

String g=WDBASQL.WDBASQLS("datastorehgh","USEDATABASE", "wilmix","C:\\Programs\\WNOSQL\\WNOSQLProgramfiles\\WNOSQL");

String t= WDBASQL.WDBASQLS("loginuser","pwduser",1,"Wilmix", "Wilmixjemin12345",1,5,g);

WDBASQL.Query("SelectAll","student" ,"0",null,15,"","",, null,"",0," ","",c,null,t,1,1);

}

</DATA>

2) Apply SelectOrderByASC to the PLSQL to table Orders for 0 to 19 records what happens?

<PACK>

<USE> CDollar.WDBA; //load CDollar.WDBA libraries

<DATALIB> ps // namespace ps

<DATA>

public <CLASS> DATA

{

public void main()

{

String g=WDBASQL.WDBASQLS("datastorehgh","USEDATABASE", "wilmix","C:\\Programs\\WNOSQL\\WNOSQLProgramfiles\\WNOSQL");

String t= WDBASQL.WDBASQLS("loginuser","pwduser",1,"Wilmix", "Wilmixjemin12345",1,5,g); char c=' ';

WDBASQL.Query("SelectOrderByASC","Orders","0" ,null,19,"123","",null,"",0,"","",c,null,t,1,1);

}

=================================================================================================

UNIT - 7 : WNOSQL(WSQL*)-PLSQL Programming

================================================================================================

WNOSQL(*) PLSQL follows basic WNOSQL(*) api syntax WNOSQL(*) put all the results in arraylist

for future use.

Program-1:

Write a program to display the matching data rows and

perform innerjoins between two table.

<WNOSQL> // Beginning of wnosql plsql program

<PACK> //load all wnosql packages

<USE> CDollar.WDBA; //use CDollar.WDBA packages

<DATALIB> ps // create name space ps

<DATA> //write wnosql logic public <CLASS> DATA

{

public void main() //like C main

{

//kindly refer wnosql fundemantals

String g=WDBASQL.WDBASQLS("datastorehgh","USEDATABASE", "wilmix","C:\\Programs\\WNOSQL\\WNOSQLProgramfiles\\WNOSQL");

String t= WDBASQL.WDBASQLS("loginuser","pwduser",1,"Wilmix", "Wilmixjemin12345",1,5,g);

char c=' ';

ArrayList arhd1gy =WDBASQL.Query("MATCH","Orders" ,"0",null,19,"0001"," ",null,"",0,"1","",c,null,t,1,1);

ArrayList arhd1gy1 =WDBASQL.Query("MATCH","Orders" ,"0",null,19,"0002"," ",null,"",0,"1","",c,null,t,1,1);

ArrayList arhd1gyy =WDBASQL.Query("MATCH","Orders" ,"0",null,19,"0003"," ",null,"",0,"1","",c,null,t,1,1);

ArrayList arhd1gy1y =WDBASQL.Query("MATCH","Orders" ,"0",null,19,"0005"," ",null,"",0,"1","",c,null,t,1,1);

ArrayList artr11= new ArrayList();

for(int i=0;i<arhd1gy.size();i++) artr11.add(arhd1gy.get(i));

for(int i=0;i<arhd1gy1.size();i++) artr11.add(arhd1gy1.get(i));

for(int i=0;i<arhd1gyy.size();i++) artr11.add(arhd1gyy.get(i));

for(int i=0;i<arhd1gy1y.size();i++) artr11.add(arhd1gy1y.get(i));

ArrayList arhd1gy17 =WDBASQL.Query("MATCH","employess" ,"0",null,11,"0001"," ",null,"",0,"1","",c,null,t,1,1);

ArrayList arhd1gy117 =WDBASQL.Query("MATCH","employess" ,"0",null,11,"0002"," ",null,"",0,"1","",c,null,t,1,1);

ArrayList arhd1gy178 =WDBASQL.Query("MATCH","employess" ,"0",null,13,"0003"," ",null,"",0,"1","",c,null,t,1,1);

ArrayList arhd1gy1178 =WDBASQL.Query("MATCH","employess" ,"0",null,13,"0005"," ",null,"",0,"1","",c,null,t,1,1);

ArrayList artr117= new ArrayList();

for(int i=0;i<arhd1gy17.size();i++) artr117.add(arhd1gy17.get(i));

for(int i=0;i<arhd1gy117.size();i++) artr117.add(arhd1gy117.get(i)); for(int i=0;i<arhd1gy178.size();i++) artr117.add(arhd1gy178.get(i));

for(int i=0;i<arhd1gy1178.size();i++) artr117.add(arhd1gy1178.get(i));

ArrayList datas1=WDBASQL.Query("INNERJOIN","Orders","0",null,19,"employess","", artr11,"",0,"","",c,artr117,t,1,1);

}

Kindly use WNOSQL EDITOR to see the output.

Program-2: Write a Program to finding matching data rows

and perform right join, use having clause , use innerjoin in this case:

<PACK>

<USE> CDollar.WDBA;