In the post check the 4,5 and 6 entries. JP had the same problem and resolved that by changing the uvodbc.config files information. i,e; Loacl host connection.
Happy Holidays.
Search found 20 matches
- Tue Dec 26, 2006 1:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to connect to DataStage using Universe Shell
- Replies: 15
- Views: 6077
- Wed Aug 09, 2006 11:09 am
- Forum: Site/Forum
- Topic: Premium Content? (I know its been done to death, but...)
- Replies: 9
- Views: 6309
- Wed Apr 26, 2006 4:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dsjob command not working
- Replies: 9
- Views: 4017
- Wed Apr 26, 2006 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dsjob command not working
- Replies: 9
- Views: 4017
dsjob command not working
Hi
When i am issuing dsjob -run command from unix command line it is displaying command not found.why is this happening.
Thanks
When i am issuing dsjob -run command from unix command line it is displaying command not found.why is this happening.
Thanks
- Thu Apr 06, 2006 11:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7811
Substantial changes. This is now a completely different requirement. You need to incorporate some algorithm (additional stage variables) to determine whether B is missing (and, presumably, whether A ... The actual requirement is like this Ray and tried it with sunshines method: Input: ID POS NA1 NA...
- Wed Apr 05, 2006 3:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7811
- Wed Apr 05, 2006 3:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7811
- Wed Apr 05, 2006 12:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL error
- Replies: 1
- Views: 1145
SQL error
Hi all, Any idea why i am getting this error. Initial_Extract,0: Warning: CopyOfJOB1.Initial_Extract: Sybase Server warning 2762 (severity 16): The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database. I am using sybase OCI stage to extract the data and...
- Wed Apr 05, 2006 11:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7811
- Tue Apr 04, 2006 7:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7811
Sorry,Here is the complete post. Sunshine2323 wrote: Hi Smita, Job Design: Code: Input----->Transformer---->Remove Duplicate----->Output Declare stage variables as follows: StageVar =DSLink3.No StageVar1 =StageVar<> StageVar1 StageVar2 =StageVar StageVar3 =DSLink3.Type:',':DSLink3.Name1:',': DSLink3...
- Tue Apr 04, 2006 7:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7811
- Tue Apr 04, 2006 6:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7811
Code: Input----->Transformer---->Remove Duplicate----->Output Declare stage variables as follows: StageVar =DSLink3.No StageVar1 =StageVar<> StageVar1 StageVar2 =StageVar StageVar3 =DSLink3.Type:',':DSLink3.Name1:',': DSLink3.Name2 StageVar4 =IF StageVar2=1 then DSLink3.No:',': StageVar5 else Trim(...
- Tue Apr 04, 2006 6:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7811
vertical pivot
I had done a good search on vertical pivot and got some information.But in every posts somebody is asking to search vertical pivot.Is there any particular post which is having complete information.
Thanks
Thanks
- Tue Apr 04, 2006 4:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stage variables
- Replies: 19
- Views: 6350
- Tue Apr 04, 2006 3:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stage variables
- Replies: 19
- Views: 6350
ok,i can explain step by step Thanks pavan I am having 30 columns.Out of these,i am mainly concerned with 2 columns,but in output i should have all these columns. ID is the main key column. POS is the column on which my transformation depends. I am having multiples rows for the ID like he use to ho...