Sponsored Content
Top Forums Shell Programming and Scripting MSSQL or SQL SERVER or SQLSERVER? Post 302853181 by gsflash80 on Friday 13th of September 2013 11:06:43 AM
Old 09-13-2013
Question MSSQL or SQL SERVER or SQLSERVER?

hi, i'll want to try on the parameter with three possibility because mine colleagues usally to work on the other name folders.

for example:


MSSQL
SQL SERVER
SQLSERVER

Code:
case $q in
    a) echo -ne "Work database: "
        echo ""
        echo "               1) ORACLE"
        echo ""
        echo "               2) MSSQL"
        echo ""
        echo -ne "          What? [ ]\b\b"
        read -n 1 db_tip

        case $db_tip in

        1)
        db_tip="ORACLE"
        ;;

        2)
        db_tip=$(echo "MSSQL") | $(echo "SQL SERVER") | $(echo "SQLSERVER")
        ;;
        *) echo "Error, try only those number"
        esac
        echo " "

and when i use on script

Code:
cd "$db_tipo"

when on the folder have MSSQL or SQL SERVER or SQLSERVER, i'll wnat to get all files *.SQL from those folders, also when it's already only folder or two folders like MSSQL and/OR SQLSERVER and/OR SQLSERVER.
thanks
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Stored Procedure on NT/SQLServer

Hi: How will I execute a Stored Procedure that sits on NT/SQLServer. Any help would be appreciated. Thanks (3 Replies)
Discussion started by: mayohan
3 Replies

2. Shell Programming and Scripting

connect to mssql

Hi - can any one tell me is it possible to connect to mssql and fetch the data from unix shell scripts (3 Replies)
Discussion started by: ahmedwaseem2000
3 Replies

3. AIX

connect SQLSERVER from unix

I have an application working in unix accessing oracle 9i database on a IBM AIX Unix 5.2 system. I want this unix application to retrieve data from a SQL server 2000 server to oracle database. how can i connect to this SQL server database from a unix application pls help me if you can (2 Replies)
Discussion started by: samsonsimon
2 Replies

4. Solaris

Connect From VB to SQL Server

Dear All Now I can't connect from VB to Sybase on Unix. How could I do? Please help me. (0 Replies)
Discussion started by: Than Chanroeun
0 Replies

5. Shell Programming and Scripting

connecting to sqlserver from perl

Hi, I am doing a migration of Oracle database to SQLSERVER 2005.Mostly my application code is perl scripts and i want to modify the scripts so as to connect to SQLSERVER. What all would be the changes i have to make for just establishing a connection from Perl script to SQLSERVER... (3 Replies)
Discussion started by: DILEEP410
3 Replies

6. AIX

AIX to access MSSQL server

Anyone can provide a solution for how AIX to access Microsoft SQL server ? (0 Replies)
Discussion started by: hellboy01
0 Replies

7. Ubuntu

Ubuntu Bulk Insert to Windows SQLServer

Hi, Anyone can help me, I can connect from ubuntu "freetds driver" to Windows sqlserver Database and doing select, insert, update, etc. But when I try to use the Bulk Insert with these command; 1> BULK INSERT test FROM '/home/test/test.txt' WITH (FIRSTROW = 2, CODEPAGE = 'ACP',... (2 Replies)
Discussion started by: dba_macau
2 Replies

8. Shell Programming and Scripting

linux ISQL and MSSQL unload results to file

Hello, I am using suse 10.1 and isql from unixodbc to connect to a MS SQL server. I got everything to work fine. What do I need to unload the results from the sql to a file? I attempted to put unload to in my sql statement but got a error. I don't see in the isql help where it has a option to... (0 Replies)
Discussion started by: benefactr
0 Replies

9. Windows & DOS: Issues & Discussions

SQL Server

hi, am new in sql server how can i grip on sql server 2008...........plz help me. (1 Reply)
Discussion started by: jiqbal0092
1 Replies
echo(1B)					     SunOS/BSD Compatibility Package Commands						  echo(1B)

NAME
echo - echo arguments to standard output SYNOPSIS
/usr/ucb/echo [-n] [argument] DESCRIPTION
echo writes its arguments, separated by BLANKs and terminated by a NEWLINE, to the standard output. echo is useful for producing diagnostics in command files and for sending known data into a pipe, and for displaying the contents of envi- ronment variables. For example, you can use echo to determine how many subdirectories below the root directory (/) is your current directory, as follows: o echo your current-working-directory's full pathname o pipe the output through tr to translate the path's embedded slash-characters into space-characters o pipe that output through wc -w for a count of the names in your path. example% /usr/bin/echo "echo $PWD | tr '/' ' ' | wc -w" See tr(1) and wc(1) for their functionality. The shells csh(1), ksh(1), and sh(1), each have an echo built-in command, which, by default, will have precedence, and will be invoked if the user calls echo without a full pathname. /usr/ucb/echo and csh's echo() have an -n option, but do not understand back-slashed escape characters. sh's echo(), ksh's echo(), and /usr/bin/echo, on the other hand, understand the black-slashed escape characters, and ksh's echo() also understands a as the audible bell character; however, these commands do not have an -n option. OPTIONS
-n Do not add the NEWLINE to the output. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWscpu | +-----------------------------+-----------------------------+ SEE ALSO
csh(1), echo(1), ksh(1), sh(1), tr(1), wc(1), attributes(5) NOTES
The -n option is a transition aid for BSD applications, and may not be supported in future releases. SunOS 5.11 3 Aug 1994 echo(1B)
All times are GMT -4. The time now is 09:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy