 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 12 matches |
| Author | Message |
|---|---|
 Topic: porting mainframe db2 database to oracle unix server |
|
| timfoster Replies: 3 Views: 1904 |
 Forum: Database Posted: Tue Feb 06, 2007 9:21 am Subject: porting mainframe db2 database to oracle unix server |
| Kolusu,
thanks for the links. I had done some searching but was haviing no luck finding anything that would migrate a db2 database on mainframe to a different database on another server. I'll tak ... |
|
| Topic: porting mainframe db2 database to oracle unix server |
|
| timfoster Replies: 3 Views: 1904 |
Forum: Database Posted: Mon Feb 05, 2007 12:47 pm Subject: porting mainframe db2 database to oracle unix server |
| folks,
quick question. Has anyone ever had to move the data from a db2 database on a mainframe to an oracle database on a unix server. Looking for any tools that would make it easier than running ... |
|
| Topic: Is (select col from a) allowed in select of query |
|
| timfoster Replies: 4 Views: 2349 |
Forum: Database Posted: Thu Oct 19, 2006 3:17 pm Subject: Is (select col from a) allowed in select of query |
| thanks for the help | |
| Topic: Is (select col from a) allowed in select of query |
|
| timfoster Replies: 4 Views: 2349 |
Forum: Database Posted: Thu Oct 19, 2006 1:55 pm Subject: Is (select col from a) allowed in select of query |
| So with DB2 then you are not allowed to use the second select the way I am trying? As you mention, it needs to be added to the from clause to create a temporary table which I can join to. Something ... | |
| Topic: Is (select col from a) allowed in select of query |
|
| timfoster Replies: 4 Views: 2349 |
Forum: Database Posted: Thu Oct 19, 2006 12:47 pm Subject: Is (select col from a) allowed in select of query |
| Folks,
can anyone tell me if the following works in db2. I am trying to use the second select to get a column from a table that I don't want to add to my main query although I suppose I can us ... |
|
| Topic: trying to output a single quote from db2 |
|
| timfoster Replies: 10 Views: 7964 |
Forum: Database Posted: Thu Aug 24, 2006 12:16 pm Subject: trying to output a single quote from db2 |
| Folks, thanks for the replies. The column in question was defined as null and I am not able to change this. The value() function worked to convert it so I have it now without the . at the end.
t ... |
|
| Topic: trying to output a single quote from db2 |
|
| timfoster Replies: 10 Views: 7964 |
Forum: Database Posted: Wed Aug 23, 2006 7:25 pm Subject: trying to output a single quote from db2 |
| actually the field acctno is a char(25). Assume that the field contains
1815&&&4070S80086 the following commands when run using the bb2 unload utility give the following output ... |
|
| Topic: trying to output a single quote from db2 |
|
| timfoster Replies: 10 Views: 7964 |
Forum: Database Posted: Tue Aug 22, 2006 8:34 pm Subject: trying to output a single quote from db2 |
| Folks,
I have some db2 unload jobs and I need to actually include a single qoute in the file it creates. Is there a way to do this in db2. what I am trying to do is something like se ... |
|
| Topic: DSNTIAUL and formatting of output |
|
| timfoster Replies: 8 Views: 12264 |
Forum: Database Posted: Mon Aug 14, 2006 8:25 am Subject: DSNTIAUL and formatting of output |
| folks,
thanks for all the help. The download is working as I need it to now. |
|
| Topic: DSNTIAUL and formatting of output |
|
| timfoster Replies: 8 Views: 12264 |
Forum: Database Posted: Fri Aug 11, 2006 8:03 am Subject: DSNTIAUL and formatting of output |
| folks,
thanks for all the responses. I have been able to get rid of the two bytes in question. Just for my own understanding. Kolusu - you mention the constants are treated as Varchar fields a ... |
|
| Topic: DSNTIAUL and formatting of output |
|
| timfoster Replies: 8 Views: 12264 |
Forum: Database Posted: Thu Aug 10, 2006 3:13 pm Subject: DSNTIAUL and formatting of output |
| Folks, a quick question. When I run an unload of a table using DSNTIAUL with the SQL parameter each coulmn unloaded has two .. at the end of the data. I want to load the file created into an excel ... | |
| Topic: determining creation of gdg for use in creation of jcl |
|
| timfoster Replies: 2 Views: 1993 |
Forum: TSO and ISPF Posted: Fri Jul 09, 2004 8:32 am Subject: determining creation of gdg for use in creation of jcl |
| I have the following scenario that I am trying to design a solution for
we have a number of gdg's on both disk and tape. We want to use the creation date of them in dynamically created jcl that wi ... |
|
All times are GMT - 5 Hours |