#DateForumTypeThreadPost
12414 Aug 2015 @ 08:51 PDTDatabaseTopicAdhoc SQL requestHi All, Below request has a solution.But need optimal solution.Appreciate your help. Scenario: 1)I have a table with 160 columns and daily partitioned.Each partition contains 46 million rows. 2...
12313 May 2015 @ 07:47 PDTDatabaseTopicPartitionHi ,  I have a partitioned table from 2013 and having almost 550 partitions.Most of the data looks redundant except the load date.So ,planning to identify the changes and remove the same attr...
12223 Mar 2015 @ 08:23 PDTDatabaseReplyExecute a set of DDL's as a single scriptYes.Those statements will be checked in DEV and QA.But as part of the automation process,we prior check and execute. We have all the create statements in one file and DML's in another.While pl...
12122 Mar 2015 @ 07:09 PDTDatabaseTopicExecute a set of DDL's as a single scriptHi All,  I have a set of DDL's where I need to execute them only all the syntaxes are correct else I dont need to execute any of the statement in the script. I tried with MSR and came to...
12022 Mar 2015 @ 07:05 PDTDatabaseReplyFailure 3932 Only an ET or null statement is legal after a DDL Statement.I executed like MSR not separately.
11920 Mar 2015 @ 02:27 PDTDatabaseTopicFailure 3932 Only an ET or null statement is legal after a DDL Statement.Hi  I am trying to execute the MSR as below.It's throwing error as  *** Failure 3932 Only an ET or null statement is legal after a DDL Statement. Could anyone help me in this rega...
11808 Jan 2015 @ 09:36 PSTDatabaseTopicDifference between accessing single Partition and Multiple partitionsHi, I have a table partitioned on DATE column with INTERVAL '1' month.I have the data for Jan and Feb months in their own partitions. Suppose I queried the data selecting the two months d...
11710 Dec 2014 @ 09:58 PSTDatabaseTopicQuerying a partitioned tableSuppose there is less data in an already date partitioned table. Like,if we only have the last 3 months of data in the table will it perform faster during queries. When querying the tables the...
11610 Dec 2014 @ 09:51 PSTDatabaseTopicJoin on different datatypeHi All, I hgave a table of huge size say 750 GB contains trillions of records.Daily we process millions of records.There is a join on INTEGER and 36 character alpha numeric key.Could you please le...
11506 Nov 2014 @ 02:12 PSTDatabaseReplyRegular Expression to check the time formatI have done the below one. SELECT REGEXP_SIMILAR('00:00:00','[0-9]{2}:[0-9]{2}:[0-9]{2}','c') But not sure that the time contains like 78:78:78,it also would pass. Any he...
11406 Nov 2014 @ 12:38 PSTDatabaseTopicRegular Expression to check the time formatHi Recently we had a bad data coming from the source and storing as character field.Later they are converting to time format. Meanwhile,I need to verify the format coming from the source.  ...
11303 Nov 2014 @ 12:46 PSTDatabaseReplyInvalid Time:)   Oversight.Thank you.
11230 Oct 2014 @ 10:56 PDTDatabaseTopicInvalid TimeHi I have a varchar field and trying to insert data like below.It's saying Invalid time.In general,varchar filed should accept alphanumeric.   CT DU ( TM VARCHAR(50) CHARACTER SET L...
11101 Aug 2014 @ 07:37 PDTDatabaseReplyGet the minimum date if the consecutive code is sameAnd I have used the below one and got it.   SEL EFF_DT,COD,RANK() OVER(ORDER BY EFF_DT RESET WHEN COD<>MAX(COD) OVER(ORDER BY EFF_DT ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)) FRO...
11001 Aug 2014 @ 07:26 PDTDatabaseTopicGet the minimum date if the consecutive code is sameCT KBB(DT DATE,COD VARCHAR(1)) INS INTO KBB VALUES('2014-01-01','A'); INS INTO KBB VALUES('2014-01-02','A'); INS INTO KBB VALUES('2014-01-03','D'...
10924 Jul 2014 @ 01:43 PDTDatabaseTopicComplex SQL ScenarioI have a table with multiple employees,the records needs to be picked up is on different conditions. I have done them one by one and did UNION.But I am looking for any other manner.Pleas ethrow a...
10829 Jun 2014 @ 11:46 PDTDatabaseTopicSkewfactorHi , I fired the below query on a table and got 0.57 as the skew factor.Is it tolerable or not?   select tablename, sum(currentperm)/(1024*1024) as Currentperm, (100-(avg(currentperm)/m...
10702 Jun 2014 @ 11:33 PDTToolsReplySIGTREM error during MLOADUSING Ckpt(VARBYTE(1024)) INSERT IDW_UAT_ERR.ML_TABLENAME (Logtype, Seq, MLoadSeq, MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4, MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,...
10602 Jun 2014 @ 10:32 PDTToolsTopicSIGTREM error during MLOADHi  I am facing an error SIGTERM during MLOAD. 19:18:25 UTY0816 Internal error, SIGTERM caught 3 times, logging off sessions... It's occuring in the DML Transaction Phase.Could anyone ...
10514 May 2014 @ 02:16 PDTDatabaseReplyString FunctionsHi You can try this way,if you are using <14 version.   SEL SUBSTR('A:B:C',1,INSTR('A:B:C',':',1,1)-1), SUBSTR('A:B:C',INSTR('A:B:C',':'...
10412 May 2014 @ 01:00 PDTDatabaseTopicDelete taking more timeHi Any clueon the below code. Old code: DELETE FROM TRANSACTION_ T1 WHERE EXISTS ( SELECT 1 FROM POS_DETAILS T2 WHERE T1.HDR_ID=T2.HDR_ID AND T1.CNTL_ID40 ); takes 6 mins New...
10308 Apr 2014 @ 10:38 PDTDatabaseReplyRow logging into ET tableProblem got resolved.I have changed the CHAR(2) field to VARCHAR(2).
10203 Apr 2014 @ 06:33 PDTDatabaseTopicExecution time for PI and NoPI for 30 million records is sameHi I have loaded a table using with 4 million records a my source file with PI and with NoPI using TPT connection.It shows a gain. When I load a 30 million record file with PI and with NoPI.It do...
10103 Apr 2014 @ 06:04 PDTDatabaseTopicJoining NoPI table and Target table with PIHi I load my stage table with NoPI for faster loading.Later i am joining the stage with the target on some columns.How does it affect as I am joining NoPI table with PI table?
10002 Apr 2014 @ 05:42 PDTDatabaseTopicRow logging into ET tableHi I have a table with 3 columns which loads thru FLOAD script CT DEMO( DT VARCHAR(10), CODE CHAR(2) DESC VARCHAR(255) ) My file is 2014-04-02|13|demo This is being logged in ET table and ...

Pages