Search found 653 matches
- Tue Apr 18, 2006 3:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Permissions on DataStage Category ?
- Replies: 4
- Views: 1756
I've been playing a lot with DataStage security, security on categories is not possible. To make jobs read-only use something as: UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO'; To make shared containers read-only: UPDATE DS_CONTAINERS SET READONLY = 'RO' WHERE READONLY = 'NRO'; For...
- Fri Apr 14, 2006 12:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Handling Line Terminator's
- Replies: 13
- Views: 3631
- Fri Apr 14, 2006 10:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Handling Line Terminator's
- Replies: 13
- Views: 3631
- Fri Apr 14, 2006 10:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Handling Line Terminator's
- Replies: 13
- Views: 3631
Re: Handling Line Terminator's
First if it's possible to get the source fixed, fix it. For the rest there are numerous options: 1) pre-process the files outside of DataStage, call a script before running the job that puts the line terminators right. 2) Use something as Sequential file -> transformer -> ... in which you read lines...
- Fri Apr 14, 2006 10:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS_JOBOBJECTS & This item has no design time information
- Replies: 7
- Views: 3916
Re: DS_JOBOBJECTS & This item has no design time informa
I don't think Ascential/IBM would like customers to share their serial numbers ;-) Now for the problem of deleting a project directory without going via Administrator... the following should work but completely at your own risk: - Take a backup of all DataStage files... Installation directory, ds pr...
- Fri Apr 14, 2006 10:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Patch for oracle stage
- Replies: 0
- Views: 691
Re: Patch for oracle stage
No patch is required. Go to your DBA's and ask them to help you set your Oracle client settings right on the server where DataStage runs. What you see happening now depends on a combination of Oracle client settings and Oracle instance settings so a general answer is not that easy given. Also if you...
- Fri Apr 14, 2006 10:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: I am getting error while calling UtilityRunJob from a routin
- Replies: 7
- Views: 4168
What about the following... the original error is an indication it can't find the UtilityRunJob routine
Ogmios
Code: Select all
Deffun UtilityRunJob(Name, PA, R,W) Calling "DSX.UTILITYRUNJOB"
Arg1 = "TestJob"
Str = UtilityRunJob(Arg1,"","","")
Ans = Str
- Fri Apr 14, 2006 9:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how can we split into multiple records
- Replies: 10
- Views: 3744
Moreover :D ... if you want to keep the amnt's in order, something as:
Ogmios
Code: Select all
select ID, sales_typ1_amnt, '1' as order
from yourtable
union
select ID, sales_typ2_amnt, '2' as order
from yourtable
union
select ID, sales_typ3_amnt, '3' as order
from yourtable
order by ID, order
- Fri Apr 14, 2006 9:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how can we split into multiple records
- Replies: 10
- Views: 3744
Use the database Luke. Do something as follows in a DB stage:
Ogmios
Code: Select all
select ID, sales_typ1_amnt
from yourtable
union
select ID, sales_typ2_amnt
from yourtable
union
select ID, sales_typ3_amnt
from yourtable
- Fri Apr 14, 2006 2:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic build of Job Parameter for defining SQL source
- Replies: 4
- Views: 1773
For the OP's problem... a way out via DataStage would be by writing a pure BASIC job. In BASIC you can compose your SQL based on some reference table and then execute that. It's harder than just a GUI job, the problem with those is that you can't dynamically create SQL statements. There are some way...
- Thu Apr 13, 2006 4:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS_JOBOBJECTS & This item has no design time information
- Replies: 7
- Views: 3916
Re: DS_JOBOBJECTS & This item has no design time informa
For the problem of your deleted project... There's a procedure for it, but I can't find it right now. Probably someone else still has a pointer to it. Ascential/IBM have it for sure (that's where I got it from originally). For your missing design time information... you may have exported less than y...
- Thu Apr 13, 2006 4:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: User Defined sql in ORAOCI
- Replies: 9
- Views: 3570
Re: Remove the "--"
Ok... a new hunch... - Analytic functions are not supported in all Oracle8i versions. They are supported from Oracle9i. - So could it be you're using the OCI8 stage instead of the 9 version? It works for your SQL Editor as you have the same version of client and server, while it doesn't work in Data...
- Thu Apr 13, 2006 3:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: User Defined sql in ORAOCI
- Replies: 9
- Views: 3570
Re: Remove the "--"
Can you post your new query?thank you, but it is not the problem. i tried quey by removing "--" also but
it gave me same error message
Ogmios
- Thu Apr 13, 2006 3:48 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: User Defined sql in ORAOCI
- Replies: 9
- Views: 3570
- Thu Apr 13, 2006 11:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mulitple update to the table using DataStage
- Replies: 8
- Views: 6974
I have been in a similar situation the original poster is. They probably want to have kind of a summary table. They can calculate the primary key and each column separately, but they can't combine all columns in one go. E.g. imagine you compare the primary key to multiple groupings, you can determin...