Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert MS Access Queries to AIX SQL
Operating Systems AIX Convert MS Access Queries to AIX SQL Post 302925432 by bakunin on Monday 17th of November 2014 07:59:09 AM
Old 11-17-2014
You find me as dumbfounded as vbe: "SQL" (structured query language) is a quasi-standard for manipulating data in a relational database and most relational databases - Oracle, DB2, Informix, MySQL, ... support it.

AIX is an operating system. You can install a relational database software onto it (this has been done perhaps millions of times) and - if that database software supports SQL - you can run SQL-statements against it. But AIX is NOT a relational database itself and it won't understand SQL queries to the same amount as native Windows: not at all. You cannot "convert SQL queries to AIX", because there is nothing in AIX which will understand them.

When - if - you mean to isntall some SQL-capable DB software onto AIX and convert the Access-SQL to this: this might work, by and large, but Mickeysoft built in some nasty surprises for you into its so-called SQL. In fact there are some severe differences between the SQL standard everybody adheres to and what makes MS makes you believe is SQL but in fact isn't. Here are some links:

Differences Between MS-Access and Standard SQL
How does Access differ from SQL 92 standards?

And the final proof that they are not even consistent with their own tinkering on the standards:
What are the main differences between Access and SQL Server?

I hope this helps.

bakunin

/PS: sorry if i sound somewhat bitter, but half of my life i have to explain to some clueless victim of M$$'s marketing machinery that what Mickeysoft calls "X" is not anywhere near "X" but in fact some downgraded, lobotomized version of "X" with some useless and clueless extensions of their own which is doing what is supposed to be left over from a vandalized standard in a different and incompatible way. For "X" put, in no particular order: TCP/IP, HTML, SQL, SCSI, Java, .....

I might be disgruntled but i think i have earned my entitlement to it.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL queries in background?

I have to query a DB2 database, and sometimes they take a long time to produce results. Can I run these queries in the background, and if so, where will the results appear? (1 Reply)
Discussion started by: jpprial
1 Replies

2. UNIX for Dummies Questions & Answers

shell script for sql queries

Hi All, I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries... i.e 1.select * from head; 2. select * from detail; 3. delete from head; 4. delete from detail; Please let me know how to write a shell script... Thank you (1 Reply)
Discussion started by: user71408
1 Replies

3. Shell Programming and Scripting

Select SQL Queries Option

count.sh#!/bin/ksh SQL1=`sqlplus -s usr/pwd @count.sql $1 $2 $3` SQL2=`sqlplus -s usr/pwd @selectall.sql $1 $2 $3` LIST="Count Select_All" select i in $LIST do if then echo $SQL1 elif then echo $SQL2 fi done (2 Replies)
Discussion started by: killboy
2 Replies

4. Shell Programming and Scripting

Nested SQL queries within Shell script

Hi, Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows: my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g" connect... (2 Replies)
Discussion started by: shrutihardas
2 Replies

5. Emergency UNIX and Linux Support

Insert data into sql queries from a file

Hello friends, I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences. my sql query file will consist of 50.000 times the below line consecutively: insert into subscriber... (6 Replies)
Discussion started by: EAGL€
6 Replies

6. Shell Programming and Scripting

Script (with sql queries) not working using cron

Hi all, I have script, which performing sql queries and put output into file. When I run this script manually, its working fine, but when I want to schedule it with cron I am getting errors... I defined LD_LYBRARY_PATH and ,but no result. After I defined it, I am getting error: # more... (4 Replies)
Discussion started by: nypreH
4 Replies

7. Shell Programming and Scripting

Code needed to get sql queries

Hi i need code to get sql queries through a shell script for a text file input which contain the service ids iputfile I-H-2048-10GB-M I-H-4096-12GB-M I-H-2048-p1000-M the code should contain below queries among which service_id is replacable with value from input file. ... (4 Replies)
Discussion started by: surender reddy
4 Replies

8. Shell Programming and Scripting

Help with storing the output of multiple sql queries to a file

Hi All, I have a file queries.txt as follows : SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2; SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2; SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2; SELECT... (2 Replies)
Discussion started by: SriRamKrish
2 Replies

9. Programming

Join 2 SQL queries into one

Dear community, could someone help me to join 2 queries into one? Basically it's the same query with different clauses (please notice the FIELD3 filters and related counters into the subquery): SELECT A.FIELD1,A.FIELD2,A.FIELD3 FROM TABLE A INNER JOIN ( SELECT FIELD1,... (3 Replies)
Discussion started by: Lord Spectre
3 Replies

10. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

LEARN ABOUT DEBIAN

sql::translator::parser

SQL::Translator::Parser(3pm)				User Contributed Perl Documentation			      SQL::Translator::Parser(3pm)

NAME

       SQL::Translator::Parser - describes how to write a parser

DESCRIPTION

       Parser modules that get invoked by SQL::Translator need to implement a single function: parse.  This function will be called by the
       SQL::Translator instance as $class::parse($tr, $data_as_string), where $tr is a SQL::Translator instance.  Other than that, the classes are
       free to define any helper functions, or use any design pattern internally that make the most sense.

       When the parser has determined what exists, it will communicate the structure to the producer through the SQL::Translator::Schema object.
       This object can be retrieved from the translator (the first argument pass to parse) by calling the schema method:

	 my $schema = $tr->schema;

       The Schema object has methods for adding tables, fields, indices, etc.  For more information, consult the docs for SQL::Translator::Schema
       and its related modules.  For examples of how this works, examine the source code for existing SQL::Translator::Parser::* modules.

AUTHORS

       Ken Youens-Clark, <kclark@cpan.org<gt>, darren chamberlain <darren@cpan.org>.

SEE ALSO

       perl(1), SQL::Translator, SQL::Translator::Schema.

perl v5.14.2							    2012-01-18					      SQL::Translator::Parser(3pm)
All times are GMT -4. The time now is 04:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy