cast(convert(varchar(8), getdate(), 112) as int)

it didn't work for me man

I am trying this from 5 hrs and unable to get a solution.

In target table i have that column as numeric.

I tried getdate() with datatype databasedate but it is...

Do you know which datatype returns only date like 2009-12-21

I want to convert that date to 20091221

I got it

Thank you very much

Thank you vey much for detailed explanation

As you said i right clicked the .bat file and clicked EDIT

It opened in a notepad

Can you explain me what this code is doing

set NLS_DATE_FORMAT=Mon dd YYYY HH:mi:ssAM

REM set...

I did as you said and i got it right.

But i didn't understand

shp_dt_key_no = dbo.awf00220_ord_fact_shp_dt(HDR.CNTRY, HDR.DLVR_DT, HDR.LAST_SHP_DT)

How...

I am sorry then.

I dont know which technology is this

So this is oracle pl/sql, right?

Thanks guys for info.

sure man this time i will come with correct code

I think i got it

ALTER TABLE DWSODS01.DWT00301_ORD_DTL_OMS

ADD (COMB_ORD_FLG NUMBER(5,0) NOT NULL);

ALTER TABLE DWSODS01.DWT00301_ORD_DTL_OMS

MODIFY COLUMN COMB_ORD_FLG DEFAULT 0;

I think this one is correct.

But the problem is i am altering two...

I am sorry if i make you guys frustrated.

I am seeing online and writing those queries, even i am testing them but i am getting errors.

I am just asking if...

How about this code

ALTER TABLE DWT00050_IMC_CCYYMM_FACT

ADD CONTRB_DISTB_FLG char(1) [DEFAULT 0]

ALTER VIEW view_name

AS

SELECT ("col1", "col2", "col3", "col4")

FROM table_name

Please check this syntaxes(NOT ONLY SYTAXES BUT A CODE TO RUN FAST)

Is this syntax correct

I want to add column to a table and set default value for that column...

In datawarehouse server i have to add column called CONTRB_DISTB_FLG to the view DWV00050_IMC_CCYYMM_FACT

I can do it.

But specifically there are two different sections which my boss gave

1) Datawarehouse Server

2)...

I have to do changes to metadata.

but i dont understand those terms at all except mouse-over element (got little bit about that but have to know how to code)

Anyways thanks...