Thank you both for your replies.
Both replies are good enough for me !
:D
Search found 16 matches
- Mon Mar 13, 2006 6:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to get the ascii code for the first character in a strin
- Replies: 3
- Views: 2251
- Mon Mar 13, 2006 3:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to get the ascii code for the first character in a strin
- Replies: 3
- Views: 2251
How to get the ascii code for the first character in a strin
Hello, I need to check if a column data is numeric or character. the data I get can only come in 2 ways for that column number or varchar2 ( the datatype of the column is ofcourse varchar2 ) I thought I'll just check for the ascii range of the first character ( If it is not between Ascii(48) and Asc...
- Wed Feb 15, 2006 7:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: hOW CAN i IMPLEMENT A SQL 'BETWEEN' IN AN TRANSFORMATION
- Replies: 1
- Views: 1719
hOW CAN i IMPLEMENT A SQL 'BETWEEN' IN AN TRANSFORMATION
Hi All, I'm have 2 tables A: have person age B: A certain id for age range. meaning : Person with age value of 24 in table A will mean in table B id : 3 start_age: 20, end_age: 25 so when I join these table in SQL and ask for the id the sql statement will look like this: select b.id from a,b where a...
- Thu Feb 02, 2006 9:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to prevent a column from being updated in an Insert/Upda
- Replies: 8
- Views: 4420
- Tue Jan 31, 2006 8:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to prevent a column from being updated in an Insert/Upda
- Replies: 8
- Views: 4420
How to prevent a column from being updated in an Insert/Upda
Hello, I have a table that I'm inserting/updating . I want to add two columns one 'Insert_date' and 'Update_date' How can I make sure that the insert column is not updated and will only only be loaded once ( When the record is created ) I do not want to split my DS into seperate operations i.e. - on...
- Tue Jan 31, 2006 2:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Importing sequences from Oracle DB
- Replies: 5
- Views: 3307
- Mon Jan 30, 2006 5:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Importing sequences from Oracle DB
- Replies: 5
- Views: 3307
jzparad, this is the error message I get when I try to 'View_Data' : ' DS_DIM_LANGUAGE..Oracle_OCI_15: ORA-08002: sequence SEQ_LANGUAGE.CURRVAL is not yet defined in this session DS_DIM_LANGUAGE..Oracle_OCI_15.DSLink1: DSP.Open GCI $DSP.Open error -100.' the job Is Set : Oracle_source, Oracle_select...
- Mon Jan 30, 2006 3:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Importing sequences from Oracle DB
- Replies: 5
- Views: 3307
Importing sequences from Oracle DB
Hello, For a certain table I need to create a surrogate key. I created a sequence in Oracle .... Now How can I import this sequence into DS ? I tried doing it with : 'Select seq.nextval from dual' but that failed ! I donot want to have a DS Internal sequence as I do need this sequence accessible. Th...
- Tue Jan 24, 2006 5:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: HOW TO CREATE A CASE STATEMENT IN TRANSFORMER
- Replies: 3
- Views: 14352
Thanks
Thanks, that works just fine
- Tue Jan 24, 2006 3:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: HOW TO CREATE A CASE STATEMENT IN TRANSFORMER
- Replies: 3
- Views: 14352
HOW TO CREATE A CASE STATEMENT IN TRANSFORMER
Hello, I have 2 tables: 1. Country 2. Language In the country table for each Country there are ALL the languages available - meaning: Country = FR Language = US,NL,DE .... Country Language FR______US FR______NL FR______FR What I am trying to create is for each country only the relevant languages + E...
- Tue Jan 17, 2006 4:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calculating age using date
- Replies: 9
- Views: 27180
Thanks
Thanks all for replying.
I eventualy decided to embed this calculation in the way I derivr the column from the DB.
Thanks.
I eventualy decided to embed this calculation in the way I derivr the column from the DB.
Thanks.
- Tue Jan 17, 2006 2:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calculating age using date
- Replies: 9
- Views: 27180
Calculating age using date
Hello, How can I calculate a person age using dates in a transformation in SQL it would look something like that : SELECT round((SYSDATE - to_date('01/01/2005','dd/mm/yyyy'))/365) FROM dual I have the birthdate of the person and in order to calculate the age I'm substructing the birthdate from SYSDA...
- Tue Jan 10, 2006 1:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Recieving a parameter from a stored procedure
- Replies: 6
- Views: 3330
- Mon Jan 09, 2006 6:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Recieving a parameter from a stored procedure
- Replies: 6
- Views: 3330
Well to be accurate, I'm not sure what exactly you are reffering to. I open anew server job and drug'n'drop the stored procedure ICON from the pallete --> I create a transformation --> and a target table. I map the procedure results( I think ) to the proper target column. Hope this helps to clarify ...
- Mon Jan 09, 2006 6:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Recieving a parameter from a stored procedure
- Replies: 6
- Views: 3330
Re: Recieving a parameter from a stored procedure
Just to confirm are you actually using the stored procedure stage or have you written a job which gets data from a stored procedure.[/quote] I'm Using a Stored procedure stage, But if you have any suggestions on how to implement the stored procedure into a regular job and getting the necessary resul...