After Work
Old Town Social
in Chicago, on North Ave, near Cleveland. Great selection of tap beers.
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
Sybase
»
UNIX
»
Commands
»
BCP data to/from a flat file
/* export */
/apps/sybase/bin/bcp dbname..tablename out /data/data01.bcp -c -Ujsmith -Pyankees -Sserver -I/apps/sybase/interfaces
/* import */
/apps/sybase/bin/bcp dbname..tablename in /data/data01.bcp -c -Ujsmith -Pyankees -Sserver -I/apps/sybase/interfaces
/* BCP table "employee" to file named test1.txt */
/apps/sybase/bin/bcp dev_db..employee out test1.txt -c -t \\t -r \\n
-Sserver -Ujsmith -I/apps/sybase/interfaces
/* BCP file named test2.txt into table employee */
/apps/sybase/bin/bcp dev_db..employee in test2.txt -c -t \\t -r \\n
-Sserver -Ujsmith -I/apps/sybase/interfaces
Parms for each command:
database
table
in/out
character format specified (-c)
tab is the field separator (-t \\t)
newline is the record separator (-r \\n)
server
user
interfaces
|
|
|
Get the latest Rocket99 news and tech tips via
|
