Re: "Copying" PF-DTA to client via RDi's "Make Available Offline" generates a .OAR file

The point of the exercise was to demonstrate to my manager that, whoever in
the organization (likely an auditor) put the clamp on using any dev-box
database function in Data Studio, Navigator, SQuirreL, Excel, or basically
any ODBC/JDBC tool we have here, for the express purpose of keeping our
very sensitive data secure, failed to understand that any developer with a
green screen can copy/paste this sensitive data into a client side file and
make off with it. The RDi function to "make available offline" just proves
another vulnerability. For that matter, I could could write a
CSV-formatted file to a source file, and use the RDi editor to quickly
copy/paste to a client-side file.

There was no desire to edit the data and put it back on the server.

RDi, in fact, does have a function to view a table, but it is (AFAICT)
strictly read-only, with no ability to copy/paste it in Windows.

- Dan

On Wed, Mar 18, 2015 at 2:36 AM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Tue, Mar 17, 2015 at 5:52 PM, Dan <dan27649@xxxxxxxxx> wrote:

But, once extracted, I'm guessing I need an editor that reads
EBCDIC. Any recommendations?

Well, I would have thought RDi does! (That's only partly a joke.)

My hex editor of choice, which does read EBCDIC and is freeware, is HxD:

http://mh-nexus.de/en/hxd/

Now, forgive me for being ignorant of RDi-centric workflows, but what
do you do with this PF once you've got a local copy? If it can
somehow be used by RDi to check your source code (verify you've got
the right field names and are using them appropriately, etc.), then
OK. I would imagine there's no other choice than to have it the way
RDi gives it to you (because it's really giving it to itself).

But if you want a local copy so that you can inspect the data, then
either RDi should already have some facility for this, or you really
ought to consider working with the data in some other form.

...