what and where is this "vincent blog"?
cannot find w google search
THANKS!
Search found 15 matches
- Mon Feb 03, 2020 4:37 am
- Forum: General
- Topic: Datastage V8 certification - training material ?
- Replies: 6
- Views: 18317
- Mon Jul 18, 2005 11:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UanableToRead rec err in Version Control ComponentRetreival
- Replies: 0
- Views: 1212
UanableToRead rec err in Version Control ComponentRetreival
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...
- Wed Mar 16, 2005 9:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: process for previous month data range
- Replies: 10
- Views: 5816
- Wed Mar 16, 2005 9:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: process for previous month data range
- Replies: 10
- Views: 5816
- Mon Mar 14, 2005 3:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: process for previous month data range
- Replies: 10
- Views: 5816
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...
- Mon Mar 14, 2005 2:09 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: process for previous month data range
- Replies: 10
- Views: 5816
process for previous month data range
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...
- Mon Feb 28, 2005 8:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: varchar to date conversion on DS 7.5
- Replies: 6
- Views: 5316
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...
- Mon Feb 28, 2005 4:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: varchar to date conversion on DS 7.5
- Replies: 6
- Views: 5316
- Mon Feb 28, 2005 2:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: varchar to date conversion on DS 7.5
- Replies: 6
- Views: 5316
varchar to date conversion on DS 7.5
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...
- Mon Feb 28, 2005 1:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: varchar to date
- Replies: 9
- Views: 4526
- Mon Feb 28, 2005 1:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: varchar to date
- Replies: 9
- Views: 4526
- Mon Aug 30, 2004 1:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: To retain only desired data rows after a Pivot
- Replies: 5
- Views: 3878
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...
- Mon Aug 30, 2004 7:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: To retain only desired data rows after a Pivot
- Replies: 5
- Views: 3878
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...
- Thu Aug 26, 2004 7:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Column name in Pivot Stage
- Replies: 11
- Views: 10253
is there a way to simply access the column name , also - to
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...
- Wed Aug 25, 2004 11:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Column name in Pivot Stage
- Replies: 11
- Views: 10253
how to get column name as a dat field with Pivot
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...