Sponsored Content
Operating Systems AIX Convert MS Access Queries to AIX SQL Post 302926114 by gandolf989 on Friday 21st of November 2014 08:40:14 AM
Old 11-21-2014
Quote:
Originally Posted by bakunin
This is generally correct, but in detail one might experience problems. For instance: if i remember correctly Access treats undefined logical values as FALSE, standard SQL defines them as being "undefined". If your SQL query relies on this it might be syntactically correct but still not doing what it should.

I hope this helps.

bakunin
That is a good point, but this is precisely where the testing would come in. Since the OP will have renamed the original tables in the Access database, he can take several attempts at migrating the data. Plus in Access you can create functions that will translate undefined values to something else. I haven't done much Access lately but I thought that Access handled undefined data as an empty string rather than null. Either way testing will be important as well as migrating the data a number of times. But if this is your job, you have time to try it over and over until its right.
 

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
TopLevelShell(3X)														 TopLevelShell(3X)

NAME
TopLevelShell - The TopLevelShell widget class SYNOPSIS
#include <Xm/Xm.h> #include <X11/Shell.h> DESCRIPTION
TopLevelShell is used for normal top-level windows such as any additional top-level widgets an application needs. Classes TopLevelShell inherits behavior and resources from Core, Composite, Shell, WMShell, and VendorShell. The class pointer is topLevelShellWidgetClass. The class name is TopLevelShell. New Resources The following table defines a set of widget resources used by the programmer to specify data. The programmer can also set the resource values for the inherited classes to set attributes for this widget. To reference a resource by name or by class in a .Xdefaults file, remove the XmN or XmC prefix and use the remaining letters. To specify one of the defined values for a resource in a .Xdefaults file, remove the Xm prefix and use the remaining letters (in either lowercase or uppercase, but include any underscores between words). The codes in the access column indicate if the given resource can be set at creation time (C), set by using XtSetValues (S), retrieved by using XtGetValues (G), or is not applicable (N/A). TopLevelShell Resource Set Class: XmCIconic Default: False Type: Boolean Access: CSG Class: XmCIconName Default: NULL Type: String Access: CSG Class: XmCIconNameEn- coding Default: dynamic Type: Atom Access: CSG Specifies that if this is True when the widget instance is realized, the widget instance indicates to the window manager that the application wishes to start as an icon, irrespective of the XmNinitialState resource. Specifies the short form of the application name to be displayed by the window manager when the application is iconified. Specifies a property type that represents the encod- ing of the XmNiconName string. If a language procedure has been set, the default is None; otherwise, the default is XA_STRING. When the widget is realized, if the value is None, the corresponding name is assumed to be in the current locale. The name is passed to XmbTextListToTextProperty with an encoding style of XStdICCTextStyle. The resulting encoding is "STRING" if the name is fully con- vertible to "STRING," otherwise "COMPOUND_TEXT." The values of the encoding resources are not changed; they remain None. Inherited Resources TopLevelShell inherits behavior and resources from the following superclasses. For a complete description of each resource, refer to the man page for that superclass. VendorShell Resource Set Class: XmCAudibleWarning Default: XmBELL Type: unsigned char Access: CSG Class: XmCButtonFontList Default: dynamic Type: XmFontList Access: CSG Class: XmCDefaultFontList Default: dynamic Type: XmFontList Access: CG Class: XmCDeleteResponse Default: XmDESTROY Type: unsigned char Access: CSG Class: XmCInputMethod Default: NULL Type: String Access: CSG Class: XmCKeyboardFocusPolicy Default: XmEXPLICIT Type: unsigned char Access: CSG Class: XmCLabelFontList Default: dynamic Type: XmFontList Access: CSG Class: XmCMwmDecorations Default: -1 Type: int Access: CSG Class: XmCMwmFunctions Default: -1 Type: int Access: CSG Class: XmCMwmInputMode Default: -1 Type: int Access: CSG Class: XmCMwmMenu Default: NULL Type: String Access: CSG Class: XmCPreeditType Default: dynamic Type: String Access: CSG Class: XmC- ShellUnitType Default: XmPIXELS Type: unsigned char Access: CSG Class: XmCTextFontList Default: dynamic Type: XmFontList Access: CSG Class: XmCUseAsyncGeometry Default: False Type: Boolean Access: CSG WMShell Resource Set Class: XmCBaseHeight Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCBaseWidth Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCHeightInc Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCIconMask Default: NULL Type: Pixmap Access: CSG Class: XmCIconPixmap Default: NULL Type: Pixmap Access: CSG Class: XmCIconWindow Default: NULL Type: Window Access: CSG Class: XmCIconX Default: -1 Type: int Access: CSG Class: XmCIconY Default: -1 Type: int Access: CSG Class: XmCInitialState Default: Nor- malState Type: int Access: CSG Class: XmCInput Default: True Type: Boolean Access: CSG Class: XmCMaxAspectX Default: XtUnspecified- ShellInt Type: int Access: CSG Class: XmCMaxAspectY Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCMaxHeight Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCMaxWidth Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCMinAspectX Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCMinAspectY Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCMinHeight Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCMinWidth Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCTitle Default: dynamic Type: String Access: CSG Class: XmCTitleEncoding Default: dynamic Type: Atom Access: CSG Class: XmCTran- sient Default: False Type: Boolean Access: CSG Class: XmCWaitForWm Default: True Type: Boolean Access: CSG Class: XmCWidthInc Default: XtUnspecifiedShellInt Type: int Access: CSG Class: XmCWindowGroup Default: dynamic Type: Window Access: CSG Class: XmCWinGravity Default: dynamic Type: int Access: CSG Class: XmCWmTimeout Default: 5000 ms Type: int Access: CSG Shell Resource Set Class: XmCAllowShellResize Default: False Type: Boolean Access: CG Class: XmCCreatePopupChildProc Default: NULL Type: XtCreatePopupChild- Proc Access: CSG Class: XmCGeometry Default: NULL Type: String Access: CSG Class: XmCOverrideRedirect Default: False Type: Boolean Access: CSG Class: XmCCallback Default: NULL Type: XtCallbackList Access: C Class: XmCCallback Default: NULL Type: XtCallbackList Access: C Class: XmCSaveUnder Default: False Type: Boolean Access: CSG Class: XmCVisual Default: CopyFromParent Type: Visual * Access: CSG Composite Resource Set Class: XmCReadOnly Default: NULL Type: WidgetList Access: G Class: XmCInsertPosition Default: NULL Type: XtOrderProc Access: CSG Class: XmCReadOnly Default: 0 Type: Cardinal Access: G Core Resource Set Class: XmCAccelerators Default: dynamic Type: XtAccelerators Access: CSG Class: XmCSensitive Default: dynamic Type: Boolean Access: G Class: XmCBackground Default: dynamic Type: Pixel Access: CSG Class: XmCPixmap Default: XmUNSPECIFIED_PIXMAP Type: Pixmap Access: CSG Class: XmCBorderColor Default: XtDefaultForeground Type: Pixel Access: CSG Class: XmCPixmap Default: XmUNSPECIFIED_PIXMAP Type: Pixmap Access: CSG Class: XmCBorderWidth Default: 1 Type: Dimension Access: CSG Class: XmCColormap Default: dynamic Type: Colormap Access: CG Class: XmCDepth Default: dynamic Type: int Access: CG Class: XmCCallback Default: NULL Type: XtCallbackList Access: C Class: XmCHeight Default: dynamic Type: Dimension Access: CSG Class: XmCInitialResourcesPersistent Default: True Type: Boolean Access: C Class: XmCMapped- WhenManaged Default: True Type: Boolean Access: CSG Class: XmCScreen Default: dynamic Type: Screen * Access: CG Class: XmCSensitive Default: True Type: Boolean Access: CSG Class: XmCTranslations Default: dynamic Type: XtTranslations Access: CSG Class: XmCWidth Default: dynamic Type: Dimension Access: CSG Class: XmCPosition Default: 0 Type: Position Access: CSG Class: XmCPosition Default: 0 Type: Posi- tion Access: CSG Translations There are no translations for TopLevelShell. SEE ALSO
Composite(3X), Core(3X), Shell(3X), WMShell(3X), VendorShell(3X) TopLevelShell(3X)
All times are GMT -4. The time now is 12:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy