Search results for query: *

Thanks a lot. It can be acquired from all_tab_columns or user_tab_columns as well.

Thanks all. It is a very good reference.

Greetings, Is there any system view can be used to extract the default values of a table? Thanks in advance! Mike

Thanks taupirho, Unfortunately, the link is not available.

Greetings, What's different between 'NOT EXIST' and 'NOT IN' in Where clause? Thanks. Mike

Thanks taupirho.

Greetings, What does the 'RECURSIVE' mean in below function? DECODE(table_name, prior table_name,'(recursive)',table_name) Thanks in advance, Mike

The solution has been figured out. that is: start with Child = 'Given tablename' connect by prior child = parent /* list child or reverse for parent */

Hi All, How to separatly list all parent or child tables by a GIVEN Table in a schema? I don't need to have overall list in a scheam. Thanks in advance, Mike

Hello all, As dbo, I have a sybase server which is running 12.5 and there are more than 30 databases in it. I'd like to have a script to set 'bulkcopy' true to those dbs. Would you please give some advice on how to do it. Thanks in advance. Mike

Thanks a lot! Columb, I think i'm going to take the codeing method as below. if [ "$optn" = "name" ] then find . -type f -name "$2" -ls elif [ ...condition... ]; then ... more.... else find . -type f -mtime +$2 -ls fi It just seems more typing than the way in my original approach...

To kHz: The issue is how to fix the code to pass the paremater value with '*' in the script. Something is weird that it causes the syntax error when assigning a value '*' or '*.log' to a parameter, but '*.txt', '*.abc', '*.log.*' or 'a*.log' is OK. Any idea why? Thanks again

with this ? optn="-name $2" output: ~/temp>rmf.sh name "*.txt" + rmf.sh name *.txt + + tr [A-Z] [a-z] + echo name optn=name + [ name == name ] + optn=-name *.txt + find . -type f -name eli.txt ftpfile.txt section.txt test_syb.txt user.txt -ls find: bad option ftpfile.txt find: path-list...

Call your script like this: rmf.sh name "*.txt" output: ~/temp>rmf.sh name "*.txt" + rmf.sh name *.txt + + tr [A-Z] [a-z] + echo name optn=name + [ name == name ] + optn=-name '*.txt' + find . -type f -name '*.txt' -ls In above '*.txt', single quote is treated as part of tring, but not quote...

...optn=`echo "$1"| tr "[A-Z]" "[a-z]"` if [ "$1" == "name" ]; then optn="-name '$2'" else optn="-mtime +$2" fi find . -type f $optn -ls output: ~/temp>rmf.sh name *.txt + rmf.sh name eli.txt ftpfile.txt section.txt test_syb.txt user.txt There is no problem with " rmf.sh mtime 300" command

Thanks for your speedy response. to feherke, the "$optn" doesn't work. error msg find: bad option -name '*.log' find: path-list predicate-list to columb, option -name or -mtime is determined by if...then..fi. Below is the expected result return to be excuted: find . -type f -name...

Hello guys, I have a problem to pass a variable ($optn) containing quoted wild card to FIND command. for exsample. #$1=name #$2=*.log if [ "$1" == "name" ]; then optn="-name '$2'" else optn="-mtim +$2" fi find . -type f $optn -ls Please give your advise to make it work. Thanks...

Hi all, I can't to access a SAS format catalog, which was transferred (proc download and/or FTP with binary) from Unix platform to Windows (all with SASV8.2)and the ERROR msg said that file created from different operating system. But there is no problem to access the format catalog transfered...

I attempted to update a Sybase table (v12.5) with a SASv8.2 dataset and got a message as following: "ERROR: MEMBER level locking for UPDATE or RANDOM access is not supported by this engine. ERROR: PROC SQL could not undo this statement if an ERROR were to happen as it could not obtain exclusive...

Hi all, The truncate table command is written to a store procedure. However, bellow Error message came out. "TRUNCATE TABLE command not allowed within multi-statement transaction." Plz give some example to fix the erro. bellow option was set before run my store proc. sp_dboption mydb, "ddl...