Sun Aug 25 07:25:16 GMT 2024
From
/weblog/hack+and+faq
Operation Snippet
Pretty-printing floats SELECT (10 / 9)::DECIMAL(15, 3);
Copying the schema CREATE TABLE tbl AS FROM example LIMIT 0;
Shuffling data FROM example ORDER BY hash(rowid + 42);
Specifying types when reading CSVs FROM read_csv('example.csv', types = {'x': 'DECIMAL(15, 3)'});
Updating CSV files in-place COPY (SELECT s FROM 'example.csv') TO 'example.csv';
https://duckdb.org/2024/08/19/duckdb-tricks-part-1.html
(google search)
(amazon search)
Fri Apr 15 13:47:41 GMT 2022
From
/weblog/hack+and+faq
s3 tutorial -
https://www.javacodegeeks.com/2017/03/amazon-s3-tutorial.html How to Create an AWS EC2 VM -
https://mydeveloperplanet.com[..]m/2021/06/09/how-to-create-an-aws-ec2-vm Sample of running "gem" to build:
sudo amazon-linux-extras install ruby2.6 // use sudo amazon-linux-extras list to check the exact name
sudo yum -y install ruby-devel
sudo yum -y groupinstall 'Development Tools'
gem install fluent-plugin-s3 --no-document
Infrastructure as Code - Full Course -
https://www.freecodecamp.org/news/what-is-infrastructure-as-code/ Insane AWS Lambda Speed Up (Java) -
https://codingcraftsman.wordpress.com[..]2/03/25/insane-aws-lambda-speed-up-java/
(google search)
(amazon search)
Tue Sep 28 14:43:23 GMT 2021
From
/weblog/hack+and+faq
[WFClient]
CPMAllowed=Off
VSLAllowed=Off
UpdatesAllowed=Off
OutBufCountHost=118
OutBufCountHost2=118
OutBufCountClient=118
OutBufCountClient2=118
OutBufLength=512
PersistentCacheEnabled=On
MouseTimer=200
KeyboardTimer=50
[*APP*}
MaximumCompression=On
Compress=On
ZLMouseMode=1
ZLKeyBoardMode=1
http://www.vmwareinfo.com[..]ix-xendesktop-ica-optimizations-and.html Dual monitor in mac os x -
https://discussions.citrix.com[..]s-with-citrix-viewer-on-mac-os-catalina/
(google search)
(amazon search)
Wed Oct 26 10:57:16 GMT 2016
From
/weblog/hack+and+faq
Generating stub for .NET webservices from wsimport
java -Djavax.xml.accessExternalDTD=all -Djavax.xml.accessExternalSchema=all -Dhttp.proxyHost=proxyhost -Dhttp.proxyPort=8080 -Dhttp.nonProxyHosts="10.0.0.0|*.pc.internal.xxx.com" -classpath "c:\Program Files\Java\jdk1.8.0_102\lib\tools.jar" com.sun.tools.internal.ws.WsImport -b
http://www.w3.org/2001/XMLSchema.xsd -b customization.xjb
http://xxx.com/service?wsdl
(google search)
(amazon search)
Thu Mar 11 06:21:23 GMT 2010
From
/weblog/hack+and+faq
java toolbox FAQ -
http://www-03.ibm.com/systems/i/software/toolbox/faq.html bible of AS400 -
http://www.redbooks.ibm.com[..]4r5/ic2924/index.htm?info/rzahgictoc.htm CRTLIB - create library
CRTSRCPF - Create Source Physical File
WRKMBRPDM - work with members using PDM
STRACMS - SCM ( aldon lifecycle manager for iseries )
QSQLSRC - Source File for create table
WRKSPLF - check Job status
STRJRNPF - start Journal a change of a file to another -
http://publib.boulder.ibm.com[..]r2/ic2928/index.htm?info/cl/strjrnpf.htm DSPFFD, UFFD - check table schema, Display File Field Description (DSPFFD)
WRKOBJ - find object under a library, e.g. : wrkobj qgpl/rst* *file
CHGCURDIR - ction or command e.g. : CHGCURDIR dir('$DEVKW3')
DSPFD - show journal status of the file
SBMBENJOB - submit ben job
DSPSYSVAL SYSVAL(QTIME)
WRKJOB Q_JREIS
STRISDB - start debugger, e.g. : CALL PGM(*LIBL/CLRS_LST) PARM( '/HOME/ISCY1/' 'RSTLSTTAK' '1.6')
edtlibl - edit library list
common library for code - $PRDSRCBEN/QCSRC $PRDSRCBEN/H $PRDSRCBEN/QCBLLESRC $PRDSRCBEN/QCBLSRC $PRDSRCBEN/QDDSSRC
common library for sql - $PRDOBJBEN , $REFDTAREP
common library for script - $PRDSRCBEN/QTXTSRC
$PRDSRCBEN/QCSRC
COSOMSVAL
F23=more options (shift + F11 = F23)
F24=More keys
F4 = drop down kind of prompt
6:57:06 PM: Carfield W Yim/: hi... just get distracted by a call... now I created a member.... then I edit it and put the create table scripts there. However, it only allow me to put 18 lines, is that normal?
6:57:52 PM: Srikanth X Krishnaswamy/: type in the letter 'I' followed by 10 in the first column- inserts 10 lines
7:15:26 PM: Srikanth X Krishnaswamy/: Nope; I10 on the line that says 0018.00; start from the first 0
Global search
3:44:08 PM: Srikanth X Krishnaswamy/: wrkmbrpdm
3:44:29 PM: Srikanth X Krishnaswamy/: use the right source ($vvv/bbb) for example
3:44:57 PM: Srikanth X Krishnaswamy/: Option 25, hit F13 to replicate this option on all source members
3:47:36 PM: Carfield W Yim/: and how to run F13?
3:50:56 PM: Srikanth X Krishnaswamy/: shirt+F1
5:42:01 PM: Srikanth X Krishnaswamy/: Connection > Configure > 27x132 columns
(google search)
(amazon search)
Fri Jan 22 06:22:50 GMT 2010
From
/weblog/hack+and+faq
Use VBoxManage for all the tasks
$ /usr/bin/VBoxManage createvm --name Debian5 –register //The VM created is an XML file located in your home directory: ~/.VirtualBox/Machines/Debian5/Debian5.xml.
$ /usr/bin/VBoxManage createhd --filename Debian5.vdi --size 4000 --variant Fixed // created under ~/.VirtualBox/HardDisks/Debian.vdi 4GB (4,000MB) in size and with fixed size (non-expanding).
$ /usr/bin/VBoxManage storagectl Debian5 --name "IDE Controller" --add ide --controller PIIX4
$ /usr/bin/VBoxManage storageattach Debian5 --storagectl "IDE Controller" --port 0 --device 0 --type hdd --medium Debian5.vdi
$ /usr/bin/VBoxManage storageattach Debian5 --storagectl "IDE Controller" --port 0 --device 1 --type dvddrive --medium /ISO/debian-40r3-i386-netinst.iso
$ /usr/bin/VBoxManage modifyvm Debian5 --nic1 bridged --cableconnected1 on --bridgeadapter1 eth0
$ /usr/bin/VBoxManage startvm Debian5
http://www.linux-mag.com/id/7673
(google search)
(amazon search)