#DateForumTypeThreadPost
1703 Feb 2015 @ 07:01 PSTDatabaseReplyCreate a stored procedure which can operate with different similar databasesI would say it is possible to create a global stored procedure. You can pass the databasename as a variable and generate the SQL's you need and execute them
1603 Feb 2015 @ 05:40 PSTDatabaseReplyOrder By Result Difference in TD and DB2 Using Dense_Rank() Function with it I had a similar situaton where the order by gives different results between Windows and Mainframe, and the issue was resolved by setting the collating sequence as below. You can try one of the two ...
1529 Oct 2014 @ 11:19 PDTDatabaseReplyHelp with macro ​​You should be able to define the macro with multiple parameters, and pass the values to the Macro in separate fields. For ex   CREATE MACRO T (SLS_GRP VARCHAR (10), BUS_NM &nb...
1412 Feb 2014 @ 08:32 PSTDatabaseTopicParameterizing Like clause We have a requirement to mask sensitive information being loaded into the tables. Let's say we had the first three groups in place, the fourth one came in as a new requirement, and so had to...
1311 Feb 2014 @ 09:01 PSTGeneralReplyparametrics queryIf you are running in SQL Assistant, you can have parameters in your SQL and the values can be assigned at run tme. You need to do a ?variable as below. When you run the query, it will ask you for ...
1225 Sep 2012 @ 12:03 PDTToolsReplyFast Export into a Access .mdb formatThanks for the input, but, the need is to create an .mdb which needs to be FTP'd somewhere. We dont even need to open up the file. We are trying to automate an existing manual process, which in...
1125 Sep 2012 @ 09:39 PDTToolsTopicFast Export into a Access .mdb formatHello .. We are using Teradata 13. I have a requirement to generate multiple .mdb files from two Teradata tables on a monthly basis. The tables are being built by an automated process, and the...
1017 Aug 2010 @ 10:40 PDTDatabaseReplyFastExport output file formatIf the volume is pretty small, may be in the thousands or so, you could also take the Microsoft Excel route, which can easily generate a .txt or a .csv file, which can be the input to your DB2 load...
904 Aug 2010 @ 09:11 PDTDatabaseReplyCharacter field Cleanup routinesThanks Rob .. I was able to get pipes out by POSITION('7C'XC IN column). Using the same method, I am able to get most of the '8B's also out, but not all. But it looks like POSITION and '1A' don't l...
829 Jul 2010 @ 12:48 PDTDatabaseTopicCharacter field Cleanup routinesHello .. We have many CHAR columns, name, address etc for example, that contains unwanted values, like @, $, %, ^, ( etc. We currently use INDEX to find the position of these characters and clean t...
729 Feb 2008 @ 04:40 PSTDatabaseReplyGlobal Tables and COLLECT STATISTICS ON TEMPORARYThanks Joe and Fred for your response .. The moment I read both your responses, I knew what was wrong in my test - exactly as what Fred said - the problem is that the second session has not yet mat...
629 Feb 2008 @ 04:36 PSTDatabaseReplyGlobal Tables and COLLECT STATISTICS ON TEMPORARYThanks Joe and Fred for your response .. The moment I read your both responses, I knew what was wrong in my test - exactly as what Fred said - . I added an insert into the table (thanks Joe) with t...
528 Feb 2008 @ 12:23 PSTDatabaseTopicGlobal Tables and COLLECT STATISTICS ON TEMPORARYHello .. The question is in regards to who gets to collect statistics on each instance of a GTT. We are trying to run some jobs in parallell, that uses lots of GTT's. If I run these jobs using the ...
413 Dec 2007 @ 01:21 PSTAnalyticsReplyHow to import data from Excel fileHi Anthony .. Here is what I found quite easy to do .. 1. Import the spreadsheet into an Access Database. You can do this very easily, no complications. 2. Export from Access to a text file with .c...
317 Nov 2007 @ 12:05 PSTAnalyticsTopicDate ValidationHello all .. In one of our processing, where we read from some tables and inserting into a new table, we have a CHR_CD and a CHR_VAL_CD field, both are defined as CHAR fields. If the CHR_CD field i...
230 Sep 2007 @ 01:55 PDTUDATopicQuery needs to run fasterHello .. I am trying to get one of my queries to run faster. Table 1 : Contains Key 1, which will be unique, about 800,000 rows. The table contains 2 other columns, which are not being used in the ...
127 Mar 2007 @ 02:45 PDTDatabaseReplyFew QuesNo of tables allowed in a Select Statement- V2R6 64No of columns allowed in a Select Statement- V2R6 1,024- V2R5 256