#DateForumTypeThreadPost
3104 Mar 2014 @ 01:48 PSTToolsReplyError in FastLoad ScriptHi Guys, Thanks for the response. Yes. The error is relating to EOF(End of File), which more relates to source input. This is the 1st time im running fastload script. Following is the format giv...
3028 Feb 2014 @ 02:35 PSTToolsTopicError in FastLoad ScriptHi All,   Below is the script for the fastload: .LOGON home/jbhatt,jugal; BEGIN LOADING DB.tables1 ERRORFILES ERR1,ERR2; DEFINE col1 (VARCHAR(50)),      &nbs...
2922 Feb 2014 @ 07:40 PSTDatabaseReplyMultiple values using case statementThanks Dieter n Raja.
2821 Feb 2014 @ 04:09 PSTDatabaseReplyMultiple values using case statementThanks Dieter.. Tat is wat i was looking for.. :) Dieter.. Im learning fast export. Im not aware on how to apply the .ACCEPT command. Is there a particular format i sud use to insert the values fr...
2720 Feb 2014 @ 11:13 PSTDatabaseReplyMultiple values using case statementAll the results of 0.
2620 Feb 2014 @ 08:44 PSTDatabaseReplyMultiple values using case statementI am relating 206 and 0 on the logic given in the where cause below. where f.colA =(case when f.colA in (:ratescale) then :ratescale --When 2061001 is true show the result when (:ratescale is no...
2520 Feb 2014 @ 04:15 PSTDatabaseReplyMultiple values using case statementHi Adeel u ve understood it rite..   When  i execute the below macro with some random number(206), part from 2061001 and 0. I expect all the rows in the output. exec samplemac('...
2420 Feb 2014 @ 12:18 PSTDatabaseTopicMultiple values using case statementHello All, Below is the example: replace macro samplemac(ratescale varchar(20)) as ( /*sel colA,colB from table1 f where f.colA =(case when f.colA in (:ratescale) then :ratescale  ...
2319 Feb 2014 @ 02:35 PSTToolsReplyHow to Run Fast Exportcorrection: where col1='&col1' and col2='&col2';
2219 Feb 2014 @ 02:33 PSTToolsReplyHow to Run Fast ExportWhen i write a FastExport Script with the .ACCEPT Command.. How should i give the data in param_file. Is there a particular format??? .LOGTABLE DB.errors; .LOGON jugalDB/JBhatt,****; .ACCEPT c...
2118 Feb 2014 @ 07:56 PSTToolsReplyHow to Run Fast ExportHi Dnoeth, I had forgot to include the semicolon while posting this issue. Sorry for that. While runnin the script in my PC i had included period in the beginnin and a semicolon in the end of the...
2018 Feb 2014 @ 03:13 PSTToolsTopicHow to Run Fast ExportHello All, I am trying to run the below script in fxp: .LOGTABLE DB.errors .LOGON jugalDB/JBhatt,jugal .BEGIN EXPORT .EXPORT OUTFILE samples111 Sel top 10 * from db.table1 .END EXPOR...
1914 Feb 2014 @ 04:55 PSTDatabaseTopicMacro Execution- Retreive 0 results  In the script when i give the below where clause Where COALESCE(colA,'')=COALESCE(NULLIFZERO(:col1) ,NULLIFZERO(:col2)) or (col1 in(NULL,'xyz));   when i pass the pa...
1814 Feb 2014 @ 02:46 PSTDatabaseReplyCheck Case Statement NULLWhen i mean it as NULL. I expect 0 results
1714 Feb 2014 @ 02:45 PSTDatabaseReplyCheck Case Statement NULLIn the script when i give the below where clause Where COALESCE(colA,'')=COALESCE(NULLIFZERO(:col1)               &nb...
1611 Feb 2014 @ 11:03 PSTDatabaseReplyCheck Case Statement NULLHi Dnoeth,   I applied the logic which u suggested with some  changes: Where COALESCE(col1,'')=COALESCE(NULLIFZERO(:col1),'',NULL) or (col1(NULL,'xyz));   Th...
1511 Feb 2014 @ 04:18 PSTDatabaseReplyCheck Case Statement NULLWhen i give it as where NULLIF(col1,:col1) =:col1 or (:col1 in ('xyz',NULL)). Does this make sense. When i pass the parameter as ' '. Then NULLIF is satisfied along wit...
1411 Feb 2014 @ 03:50 PSTDatabaseReplyCheck Case Statement NULLYes. I had hard-coded xyz. Still im not getting the result for both xyz and NULL values. When i pass the parameter as ' '(single quoates)
1311 Feb 2014 @ 03:24 PSTDatabaseReplyHow to filter NULL from the macro outputThanks Dnoeth. :)
1211 Feb 2014 @ 03:17 PSTDatabaseReplyCheck Case Statement NULLDnoeth/Saeed, where col1=(case when :col1='xyz' then 'xyz' else NULL end) when i pass a parameter xyz then the where condition satisfies and all the results displayed which are eq...
1111 Feb 2014 @ 01:49 PSTDatabaseReplyHow to filter NULL from the macro outputYes LEFT OUTER JOIN would restrict the NULL values. I am trying other possibilities to filter NULL values.
1011 Feb 2014 @ 01:44 PSTDatabaseTopicCheck Case Statement NULLHi Guys, In the case statement if i give it as mentioned below: where col1=(case when :col1='xyz' then 'xyz' else NULL end) Here if the case statement is satisfied then col1...
910 Feb 2014 @ 05:46 PSTTeradata ApplicationsReplyBad character in format or dataThanks Dnoeth.  :)    
810 Feb 2014 @ 05:44 PSTDatabaseReplyHow to filter NULL from the macro outputHi Dnoeth, Below is the example: replace macro jugal.samples_macro(id1 integer,id2 integer,course1 varchar(20),course2 varchar(20)) as ( Select d.id,d.course from (sel id,course from juga...
709 Feb 2014 @ 04:53 PSTDatabaseReplyHow to filter NULL from the macro outputYes Adeel the NULL values are bcoz of FULL OUTER JOIN. I did try to restrict by using case when the in the where clause, i tried partition by clause still i was getting the extra NULL result. I was...

Pages