I'm looking for an onpladm example to create an unload of a table with SQL where clause. I almost had it with...
onpladm create map <map> -D <database> -t <tabname> -z D
Then...
onpladm describe query <map> -F <file>
Then edit the file and change the SELECTSTATEMENT.
Then...
onpladm modify object -F <file>
But then I get an error when executing onpload...
onpload -m <map> -d /data1/tmp/unload_file -fup
I just want to unload part of a table, it is a very large table, so need to use HPL.
Thanks,
James
I'm looking for an onpladm example to create an unload of a table with SQL where clause. I almost had it with...
onpladm create map <map> -D <database> -t <tabname> -z D
Then...
onpladm describe query <map> -F <file>
Then edit the file and change the SELECTSTATEMENT.
Then...
onpladm modify object -F <file>
But then I get an error when executing onpload...
onpload -m <map> -d /data1/tmp/unload_file -fup
I just want to unload part of a table, it is a very large table, so need to use HPL.
Thanks,
James
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 67:11:34 |
Calls: | 6,488 |
Calls today: | 1 |
Files: | 12,096 |
Messages: | 5,275,151 |