Search results for query: *

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

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

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

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

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...

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...

Hi all, How to determine whether trigger setting is enable or disable status? Thanks in advance. Mike

Hi all, If I give multiple positional parms to a ksh script, I will get a error msg 'unknown test operator'. For example: $> my_script_name A101 B101 B103 My script can work OK with capture $1 $2 $3 values. But how fix it without error msg 'unknown test operator'. Thanks, Mike

Hi all, I'd like to have a loop in a stor procedure. It is simplar action like unix scrip. i.e. for mystring in a b c d do print "$mystring is in mystring" done Someone can give me a example in SP? Thanks in advance. Mike

Hi, I got a message "incorrect syntax SP_DROPOBJECTDEF " from running below code. Please someone can help me to make correction. Thanks in advance. Mike /* sql code */ IF OBJECT_ID('OTLT') IS NOT NULL BEGIN DROP VIEW OTLT SP_DROPOBJECTDEF 'OTLT' /* deletes the CIS mapping */...

Hi all, How to conditionally submit a SAS program (i.e saspgm.sas) with %include in data step without %macro statement and %if.. %then..? In below sample, the saspgm.sas will be submitted regardless what the condition is. How to make it only run when &x=1: %let x=0; data _null_; if &x=1...

Hi all, How to config or setup options to handle a large dataset to join view in sybase? I attempted to join SAS dataset with Sybase view and got a message "Error code: -21" which mean run out of resource and SAS got hanged. The SAS dataset I used has obs=2208, vars=115 and...

Hi all, Does anyone can give me a syntax to create a second temporary data library, which is separated from WORK. Thanks, Mike

Hi all, Do you know that how to catch an envirentment variable on MS-Windows since SYSGET() doesn't wok for Windows? Thanks, Mike

Hi, How to list current all subdirectory names without filenames on ksh? e.g. ls -R # list all layer subdirs and filenames. How to eliminate the filenames? Thanks, Mike

Hi All, Below codes will print the messages for each of unmatched records. How to correct it to print only one 'Not Found' message at the end of a file if the word is not found? #-------- Script -------- read string?'[Enter the old name]: ' awk '{ if ( $1 == word ) print...

Hi, does anyone have an idea to do many to many merge with MERGE statement intead of Proc Sql join. Ex. Below two datasets to be merged by X. data1 data2 Merged data should be X Y X Z X Y Z a 1 a m a 1 m a 2...

Hi, I need help on my Exce2000 VBA to be fixed. When I use Delete-Row command on the menu, I got an error message " run-time error 1004, application or object defined error". Debug points to the third line(2nd IF...) of my script below. There is no error if delete cells or whole...