Re: DB2 Control Center: Is that for DB2 on IBM i also?

[Bdietz400 <bdietz400@xxxxxxxxx>]

I wonder if using the IBM i transfer tool would help.

http://public.dhe.ibm.com/services/us/igsc/cs2/ApiSamples/

Look for IbmiTransfer.exe
I use it frequently for downloading ad hoc data in csv format.
 
--
Bryan


> On Nov 20, 2013, at 3:44 PM, rob@xxxxxxxxx wrote:
>
> I have a ticket opened with IBM Sametime.  They want me to use DB2 Control 
> Center to export some tables from the database for Sametime.  This is the 
> WAS based Sametime and yes, it does store some data in the qsys.lib file 
> system.  Admittedly this gentleman is unfamiliar with DB2 on IBM i but he 
> believes that DB2 Control Center is a client that runs on Windows or Linux 
> clients and can access DB2 on multiplatforms (including IBM i).  I don't 
> think he's actually ever used it to access db2 on IBM i.  Well, I am 
> thinking that there must be other ways to skin this cat.  He's wanting it 
> exported to a delimited file.  I figure I could use File Transfer but I 
> wondered if the database portion of the fat client System i Navigator 
> would have an 'Export' function in the tables part of database.  Nope. 
> Figuring that is deprecated I tried the web version IBM Navigator for i 
> and that does have an Export function.  Their Export function is much like 
> CPYTOIMPF (which everyone knows is just my FAVE!).  It copies the file 
> into the stream file system, not to your client.  It does have some 
> enhancements, like the datalink and other different columns allow you to 
> CAST them.  The screen goes into something like:
> ...
> normalCharacterColumn,
> normalNumericColumn,
> /* datalinkorclobColumn */,
> ...
> I change that one line to
> CAST (datalinkorclobColumn as char (128)) as datalinkorclobColumnChar,
> ...
> Now, if it just didn't error out and hang...  Oh well, now I am up to 10 
> open pmr's. Of which one could be career threatening.
>
> So, is it just a bad trip to think that 'DB2 Control Center' is a possible 
> solution?
>
>
> Rob Berendt
> -- 
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>          Garrett, IN 46738
> Ship to:  Dock 108
>          6928N 400E
>          Kendallville, IN 46755
> http://www.dekko.com
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.