31 | 04 Mar 2014 @ 01:48 PST | Tools | Reply | Error in FastLoad Script | Hi 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... |
30 | 28 Feb 2014 @ 02:35 PST | Tools | Topic | Error in FastLoad Script | Hi All,
Below is the script for the fastload:
.LOGON home/jbhatt,jugal;
BEGIN LOADING DB.tables1
ERRORFILES ERR1,ERR2;
DEFINE col1 (VARCHAR(50)),
&nbs... |
29 | 22 Feb 2014 @ 07:40 PST | Database | Reply | Multiple values using case statement | Thanks Dieter n Raja. |
28 | 21 Feb 2014 @ 04:09 PST | Database | Reply | Multiple values using case statement | Thanks 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... |
27 | 20 Feb 2014 @ 11:13 PST | Database | Reply | Multiple values using case statement | All the results of 0. |
26 | 20 Feb 2014 @ 08:44 PST | Database | Reply | Multiple values using case statement | I 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... |
25 | 20 Feb 2014 @ 04:15 PST | Database | Reply | Multiple values using case statement | Hi 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('... |
24 | 20 Feb 2014 @ 12:18 PST | Database | Topic | Multiple values using case statement | Hello 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
 ... |
23 | 19 Feb 2014 @ 02:35 PST | Tools | Reply | How to Run Fast Export | correction:
where col1='&col1' and col2='&col2';
|
22 | 19 Feb 2014 @ 02:33 PST | Tools | Reply | How to Run Fast Export | When 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... |
21 | 18 Feb 2014 @ 07:56 PST | Tools | Reply | How to Run Fast Export | Hi 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... |
20 | 18 Feb 2014 @ 03:13 PST | Tools | Topic | How to Run Fast Export | Hello 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... |
19 | 14 Feb 2014 @ 04:55 PST | Database | Topic | Macro 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... |
18 | 14 Feb 2014 @ 02:46 PST | Database | Reply | Check Case Statement NULL | When i mean it as NULL. I expect 0 results
|
17 | 14 Feb 2014 @ 02:45 PST | Database | Reply | Check Case Statement NULL | In the script when i give the below where clause
Where COALESCE(colA,'')=COALESCE(NULLIFZERO(:col1)
&nb... |
16 | 11 Feb 2014 @ 11:03 PST | Database | Reply | Check Case Statement NULL | Hi Dnoeth,
I applied the logic which u suggested with some changes:
Where COALESCE(col1,'')=COALESCE(NULLIFZERO(:col1),'',NULL) or (col1(NULL,'xyz));
Th... |
15 | 11 Feb 2014 @ 04:18 PST | Database | Reply | Check Case Statement NULL | When 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... |
14 | 11 Feb 2014 @ 03:50 PST | Database | Reply | Check Case Statement NULL | Yes. 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)
|
13 | 11 Feb 2014 @ 03:24 PST | Database | Reply | How to filter NULL from the macro output | Thanks Dnoeth. :)
|
12 | 11 Feb 2014 @ 03:17 PST | Database | Reply | Check Case Statement NULL | Dnoeth/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... |
11 | 11 Feb 2014 @ 01:49 PST | Database | Reply | How to filter NULL from the macro output | Yes LEFT OUTER JOIN would restrict the NULL values. I am trying other possibilities to filter NULL values.
|
10 | 11 Feb 2014 @ 01:44 PST | Database | Topic | Check Case Statement NULL | Hi 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... |
9 | 10 Feb 2014 @ 05:46 PST | Teradata Applications | Reply | Bad character in format or data | Thanks Dnoeth. :)
|
8 | 10 Feb 2014 @ 05:44 PST | Database | Reply | How to filter NULL from the macro output | Hi 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... |
7 | 09 Feb 2014 @ 04:53 PST | Database | Reply | How to filter NULL from the macro output | Yes 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... |