With the help of West Wind's wwDotNetBridge, you can easily have access .NET code within a VFP program.
The white paper has all the details, but this concise example will help illustrate the basic steps to running a method in a .NET assembly.
Note that wwDotNetBridge can directly access simple pro...
Datapump jobs can be monitored using
1. data dictionary views:
select * from dba_datapump_jobs;
SELECT * FROM DBA_DATAPUMP_SESSIONS;
select username,opname,target_desc,sofar,totalwork,message from V$SESSION_LONGOPS where username = 'bkpadmin';
2. Datapump status:
Note down the j...
Commands:
expdp <bkpadmin>/<bkp123> parfile=<exp.par>
*Please replace the data in <> with appropriate values as per your environment. You can add/modify parameters as per your requirements. In the above example all the remaining parameters are added in parameter files as...
Prerequisite:
Prior to user import it is a good practice to drop the schema or table imported.
Commands:
impdp <bkpadmin>/<bkp123> parfile=<imp.par>
*Please replace the data in <> with appropriate values as per your environment. You can add/modify parameters as per...
Source Server [Export Data]Target Server [Import Data]1. Create a datapump folder that will contain the export dump files4. Create a datapump folder that will contain the import dump files2. Login to database schema that will perform the export.5. Login to database schema that will perform the impor...
Once you have SCons running, create a file named SConstruct:
print('..Building World')
Now run scons:
$ scons
scons: Reading SConscript files ...
..Building World
scons: done reading SConscript files.
scons: Building targets ...
scons: `.' is up to date.
scons: done building targets.
S...
If you have modifications to share or just want to try new version in development.
$ hg clone https://bitbucket.org/scons/scons
$ python scons/src/script/scons.py
In this example you will be modifying the Marital Status drop-down list found on the Contacts form (CR302000):
To add new items to the PXStringListAttribute successor
The best way to extend drop-down items hard-coded inside an attribute inherited from the PXStringList or PXIntList attribute is b...
There are some situations where you won't be sure what type a variable is when it is returned from a function. You can always check a variable's type by using var.(type) if you are unsure what type it is:
x := someFunction() // Some value of an unknown type is stored in x now
switch x := x.(type...
This workaround helped us so much at my job (Tech Support), we made a simple batch file we could run from anywhere (We didnt have the permissions to install the actual exe). This workaround will run OpenSSL and open up the bin folder for you (cause this is where any files you create or modify will b...
First, I will place my date into a Macro Variable.
NOTE: I find that
date9. works great with IBM® Netezza® SQL and Transact-SQL. Use whichever format that works for the type of SQL you're executing.
data _null_;
call symput('testDate',COMPRESS(put(today(),date9.)));
;RUN;
%PUT ...
Filename myEmail EMAIL
Subject = "My Email Subject"
From = "[email protected]"
To = '[email protected]'
CC = '[email protected]'
Type = 'Text/Plain';
Data _null_; File myEmail;
PUT "Email content";
PUT &q...
Take note of the email type: Type = 'text/html';
Filename myEmail EMAIL
Subject = "My Email Subject"
From = "[email protected]"
To = '[email protected]'
CC = '[email protected]'
Type = 'text/html';
Data _null_; File my...
