Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. juliane26

    Is There Any Easy Way to Get a DB2 database into SQL 2000?

    Don't you have a test stage without or with little billing or billed by CPU? create there empty tables and test the SQL there. Best would be with few data sets to test functionality. For SQL Server: well, a simple copy could be done using Access: export as CSV and import to SQL Server using...
  2. juliane26

    group by cube or group by grouping

    Marc, Ties, I am actually not looking for the cube itself ( as Ties noted the complete set is probably not needed) but for constructs like GROUP BY GROUPING SETS ... there the subtotals can be defined for some level needed. And yes, we could use that in some batches and if only for checking or...
  3. juliane26

    group by cube or group by grouping

    Hi, I am aware that a group by cube is not available in DB2 z/OS V8. Any idea how to realize the same in a single SQL statement ? I cannot find anything like that in DB2 z/OS V9 documentation either: does anybody know whether it is planned to be included in future versions ? Thank you very...
  4. juliane26

    Web based database system?

    The "catch": Well, you start employing an complete set of Oracle Applications including Oracle AS and when starting to grow then there is hope for Oracle to be part of it. And then it won't be that cheap anymore: Oracle Database and Oracle Application Server do not come for free. When needing...
  5. juliane26

    Use of the N

    I liked this. Learned something. Star. Juliane
  6. juliane26

    Need Your Opinion

    MasterRacker, Depends on the size of your workgroup - 5 or 6 ok, but when all of a sudden a complete department is interested, then it becomes an issue and a problem. I am busy with SQL server only short now(2 month), but we took over already 3 Access applications for that reason, probably all...
  7. juliane26

    Need Your Opinion

    Its not so much performance: applications had to move away from Access backend (to SQLserver in our case) to enable multi-user. Juliane
  8. juliane26

    Upgrade 2000 to 2005

    You can download it for free at Microsoft: http://technet.microsoft.com/en-us/sqlserver/bb671104.aspx Juliane
  9. juliane26

    Upgrade 2000 to 2005

    Hondy, being new to the SQL Server World and having to move quite some databases to 2005 I actually used the SQL advisor first. And in two cases the tool even found something useful. OK it was packaged software which had to be upgraded too - but there are some changes in DDL which might be...
  10. juliane26

    Object Naming Standards

    John, we are setting up a new SQL 2005 environment over here to centralize SQL applications. We have for all other database system naming conventions: the strictest on the host, followed by Unix systems. In SQL server I can forget about naming conventions going down to table names or views...
  11. juliane26

    DB2 Read Only USER

    DB2 on Linux is using the Linux user authorization. So you have to define users and passwords in your linux system. the you can grant and revoke user rights to each user. there is an db2 user called 'public' - and whatever public can do is what everybody can do. so first thing you want to do...
  12. juliane26

    set column to default in db2

    Which DB2 are you using ? z/OS ? In LUW you should be able to do this. In case its LUW: which error/sqlcode do you get ? Juliane
  13. juliane26

    SQL Server Backup problem

    Which backup device do you select? Select disc (and not tape) then select 'add' and enter a path and filename(like dbname.BAK) for your backup. Juliane
  14. juliane26

    SQL server version problems

    Hi Btacy, I moved quite some databases from a SQL 2000 Server to a SQL 2005 server simply by taking a backup and restoring it on the other machine. Just adjust the path for data and log files according to your new system when restoring. If needed (ask the vendor) adjust the compatibily level...
  15. juliane26

    DTS in 2000 to SSIS in 2005 transformation

    I have a little problem with our old DTS packages. We changed them to SSIS packages. They work as long executed in a way that all connections (i.e. file sources) are local and our sqlagent(local system user) has no problem accessing them. I would like to access a remote file system and changed...
  16. juliane26

    DB2 Connect Server - quick info please

    I habe a SUN machine. On that machine is running a software communicating via CLI with DB2. So here is the DB2 client. This client connects via a DB2 connect server (on a different AIX box) to the DB2 host subsystem. We have CLI problems: the application returns rubbish and the software vendor...
  17. juliane26

    DB2 Connect Server - quick info please

    After being away from work for quite a while I need a quick update: I have a unix client(SUN) connecting via a connect server(AIX) to zOS. for applications running on the unix(SUN) box, which CLI bindfiles I need to rebind the client or the connect server ones? Thanks a lot, Juliane
  18. juliane26

    How to initialize command line env without launching new window

    not sure my answer is 100% correct for your question: we create *.bat files in Windows, e.g. for cataloging databases. And the commands all have this form: db2cmd /c /w /i "db2 catalog tcpip node xxxx remote yyy server 444 with 'Host D2A0'" also terminate etc. is no problem then and it does...
  19. juliane26

    oracle rowid pseudocolumn - anything like that in db2?

    ddiamond, when using cursors, why not using update ... where current of ... setting a commit counter then is also no problem. then you could save the trouble of using artificial rowids. Juliane
  20. juliane26

    DB2 for zOS; version and service pack level

    Interesting question. I'd say this is not possible, since on z/OS patches are applied and not fixpaks(collection of patches). So with patches you can choose single patches needed and apply only those - the version will not change then. But if you find out I would like to learn too, since when...

Part and Inventory Search

Back
Top