DSXchange

Krazykoolrohit

what is the metadata defined for the key columns? Integer or decimal?

Krazykoolrohit

Add this to the description in XML stage/ Input/ columns. "/Branches/Branch/@BRCH" Hi, What does this XPath expression do? This creates the XML data in avirtual tabular form. Is this attribute "BRCH" a part of the xml sample schema/document that "Agnes" is referring to...

Krazykoolrohit

Add this to the description in XML stage/ Input/ columns.

Code: Select all

"/Branches/Branch/@BRCH"

Krazykoolrohit

Is this a development installation? then restart the datastage server.

If the above doesnt work, restart the unix box.

PS: this should be your last option...

Krazykoolrohit

I added a Uservariable stage in the sequence and added a variable definition to be passed onto the job activity stage with the following derivation

Code: Select all

convert('/','-',Oconv(Date() - 7, "D4/YMD"))

that made it work.

Krazykoolrohit

I avoid using sysdate in a source query since I am likely to have to reload data for a specific date in the past. I use a job control job to calculate the date then pass it to the real job using DSSetParam. The job control job has a parameter which is normally left blank. This causes the job contro...

Krazykoolrohit

currdate()-1 or sysdate()-1 just without even using parameters if you are extracting the data on daily basis. the SQL is aborting when i give the following SQL. i am extracting data from DB2. wud i need to format the sysdate output to DB2 format. am using this as a filter in the SQL. between sysdat...

Krazykoolrohit

now i need to get this sysdate to the following format before passing into the SQL.

Z_PLCMT between '2007-04-06-00.00.00.000000' and '2007-04-12-00.00.00.000000'

so i need systime.or equivalent.

Krazykoolrohit

ok. lets start from begining. how do i capture yesterdays date and pass into a job using job parameters?

Krazykoolrohit

ray,

it doesnt accept oconv in SQLs. i have worked it out and made them as a parameter to the jobs. now i need to capture current date and date of a week before in the job parameters.

Krazykoolrohit

Code: Select all

stgvar1:
if  column1 <> stgvar2 then 1 else 0
stgvar2:
column1

pass all of those for which stgvar1 = 1. before the transformer make sure to sort data on column 1

Krazykoolrohit

An insert is a DML statement. It will be a logged activity. A bulk load is not the same as insert. So you want to test the inserts. Take the same sets of data and test it out. It does not depend upon how many years of data you have. It depends upon a lot of factors like record byte size, netword tr...

Krazykoolrohit

the following worked

Code: Select all

Z_PLCMT between char(DATE(#Week_Start_Date#)) || '-00.00.00.000000' and char(DATE(#Week_End_Date#)) || '-00.00.00.000000'

but have another query now.

DATE(14347) is not giving the output as '04-06-2007' instead its just passing 14347.

Krazykoolrohit

I tried the search but couldnt find anything to help me. I am passing the following SQL in the DB2 API. i need to extract data for the last week Z_PLCMT between 'DATE('#Week_Start_Date#')' || '-00.00.00.000000' and 'DATE('#Week_End_Date#')' || '-00.00.00.000000' the values for Week_Start_Date being ...

Krazykoolrohit

atleast i resolved this post Ray

DSXchange

Search found 548 matches

passing date parameter