DSXchange

what and where is this "vincent blog"?
cannot find w google search
THANKS!

doing a project initialization (select all was used) in Data stage version 7.5 Version Control - while the Retreiving Data Stage Components aspect of the initialize was running, I got the error message "Unable to read record. Error: 0 The project being initialized had a DS Designer seesion open...

Sainath.Srinivasan wrote:You are correct. The months_between was intended to use exact one month in date rather than to obtain any date that lies in the last month.

thx for the input

results to come
Bob

thanks
Carter and Ray
I will try BOTH of these - to add to our repetoire for the customer here- will keep you posted on results

GRACIAs seniors - you're the men

You can use the Oracle add_months() function to get previous month/year: prev_month_year = to_char(add_months(sysdate,-1),'MMYYYY') So your condition would look something like this: WHERE to_char(FIELD_HISTORY.MODIFY_DATE, 'MMYYYY') = to_char(add_months(sysdate,-1), 'MMYYYY') Remember to add checks...

we need to process previous month's data. so if it is any day in March we want only february data. We currenly use jobhiararchy system interacting with a param.ini file, which is set to provcess the previous run's date until th eporesent, in conjunction with an ETL_RUN_CTL tavble that stores the las...

Use an Oracle Date formatter like 'MONTH DD YYYY HH:MI AM' with your to_date(). Carter thanks but we can't guarantee it will be AM could be AM or PM Isn't there a way in a a data stage transform - in the derivation for the row - to convert from whatever the string character data is to a date /times...

our data comes in as a text varchar filed, not a date field
I did a trim on it and ran it throught the insert job, but To_Date in Ora stage does not accept it
data is varchar looking like this

DECEMBER 29 1899 12:00 AM

I'm trying to convert varchar (40) data from an Oracle DB source on unix to date data format for an oracle output table. in a DS transform, in an Xmap job input is varchar (40) - needs to convert in DS to a timestamp value that will be inserted to oracle table date column in a DS insert job. I do no...

thanks Ken - I did just start a new one
varchar to date conversion in data stage 7.5 on unix

Hi, You can use "StringToDate()" function in a PX Transformer to convert the string to a "Date" type variable. Use help for the syntax. Regards Amitava I am using Dat stage 7.5 on unix need to convert a varchar (40) coolumn data to timestamp (38) StringToDate does not exist in D...

Hold it in a Stage Variable and only increment it under the same conditions that you use to pass out a row. OK here's what I have 12 rows coming from the pivot w the same key to get rid of rows w nonkeyamt = 0, keep rows w nonkeyamt >0 and also add an incrementor to the new compound key (key,increm...

Are you facing any difficulty in connecting the ouput of the pivot stage to a transformer stage. Regards, Sumit Thanks for reply I finally found the pdf on Pivot (was iun a different place on drive than per instructions) and set up the pivot Since no way to access column name in DS, I ended up hard...

thanks what I'm wondering - is there a way to simply access the column name - is it available as a data elemnet somehow in DS so you can simply access it, put the column name for the amount that goes with that column name into a column that would then be split out in the pivot. I would want to do th...

Faced with a similar situation - how exactly do you take a column name and then access it inside the transform, to use the column name as data? In my case I have coming in one row with columns LoanNum PRSRent ProRent PRSTax ProTax, etc - there are 12 sets of PRS/PRO columns data is like this LoanNum...