Search found 142 matches
- Tue Jul 07, 2015 10:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rounding Issue
- Replies: 3
- Views: 3202
- Tue Jul 07, 2015 7:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rounding Issue
- Replies: 3
- Views: 3202
Rounding Issue
Hello all, my input is decimal 4,2 and my output is smallint. So I am using Ceil func to get the closest value.
What I am expecting is
Ceil (7.04) =7
ceil(7.94)=8
But in both cases above, the output I am getting is 8. Let me know if there is another way around.
What I am expecting is
Ceil (7.04) =7
ceil(7.94)=8
But in both cases above, the output I am getting is 8. Let me know if there is another way around.
- Thu Jan 10, 2013 12:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Loading Date
- Replies: 4
- Views: 3708
- Mon Jan 07, 2013 4:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Loading Date
- Replies: 4
- Views: 3708
Issue with Loading Date
I have this situation. Source is a csv file. I am reading everything as varchar and trying to load to Teradata. There is a column which has dates, from the source. In the transfomer I am doing a StringToDate(IP,'yyyy-mm-dd'). Issue is for 01/01/01 it is loading as 1901-01-01 instead of 2001-01-01. I...
- Mon Oct 01, 2012 12:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculate Months Since from Date
- Replies: 1
- Views: 2240
Calculate Months Since from Date
Folks, I am trying to calculate number of months since from a given date.
I know Datastage has DaysSinceFromDate and I can do either
days/30 or (days/365)*12. The second one is much accurate. Please let me know if there is a better way. Appreciate your help.
I know Datastage has DaysSinceFromDate and I can do either
days/30 or (days/365)*12. The second one is much accurate. Please let me know if there is a better way. Appreciate your help.
- Wed Aug 22, 2012 3:04 pm
- Forum: General
- Topic: Question about running job from Client
- Replies: 1
- Views: 1919
Question about running job from Client
Guys, when I am running the job from client, the job is running as 'dsadm'. But when I am running the job from cmd line with dsjob -run, the job is running with my user id. Is there a setting I can change so that the job runs as myself even from the client or is it something that was during the inst...
- Thu Mar 01, 2012 8:06 pm
- Forum: General
- Topic: How to use dsjob when there are 2 datastage installs
- Replies: 6
- Views: 4913
- Thu Mar 01, 2012 7:24 pm
- Forum: General
- Topic: How to use dsjob when there are 2 datastage installs
- Replies: 6
- Views: 4913
Thanks a lot guys for the responses. Yes I know I have to qualify the new ports but that is where I am not able to work it out. I haven't yet installed 8.7. It will be installed 2 weeks after. I am just trying to get the right syntax. My simple command that works is dsjob -run projectname jobname No...
- Thu Mar 01, 2012 4:08 pm
- Forum: General
- Topic: How to use dsjob when there are 2 datastage installs
- Replies: 6
- Views: 4913
How to use dsjob when there are 2 datastage installs
Hello all, We have IIS 8.1 right now in our environment and soon in about a month we will be installing 8.7 with out uninstalling 8.1. So we will have 2 Engines for atleast 2 to 3 months. Obviously I will be installing 8.7 on new ports. Lets assume my new dsengine is on 31540 instead of the defualt ...
- Thu Apr 14, 2011 3:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Broken Pipe Error
- Replies: 0
- Views: 2361
Broken Pipe Error
We have a Datastage job which loads Runtime statistics of any functional job. We call it Framework Job. This job runs around 500 to 600 times everyday depending on the functional jobs we have. We are having issues with this framework job on somedays, frmwork job getting aborted for no known reason. ...
- Tue Sep 14, 2010 8:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compare Environments
- Replies: 1
- Views: 2159
Compare Environments
We have a very strange situation in our production instance. There are very few jobs in PROD around 15. Occasionally they are causing a failover on our cluster and switching to secondary. There are a lot more number of jobs in test running without any noise. When we asked our Systems team, they are ...
- Mon Aug 23, 2010 4:17 pm
- Forum: General
- Topic: Multi Instance
- Replies: 1
- Views: 2283
Multi Instance
Hi all
Is there a way to find if a job is Multi instance or not, from the command line. I am guessing if dsjob -jobinvocationid would work. But dont know what will it return, if the job is not multi instance.
Any advice is really appreciated.
Is there a way to find if a job is Multi instance or not, from the command line. I am guessing if dsjob -jobinvocationid would work. But dont know what will it return, if the job is not multi instance.
Any advice is really appreciated.
- Fri Aug 20, 2010 3:42 pm
- Forum: DSXchange Testimonials
- Topic: Thanks to my friends
- Replies: 7
- Views: 24047
- Fri Aug 20, 2010 2:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Import error
- Replies: 2
- Views: 3407
DB2 Import error
I am trying into import Table Defnitions from DB2 using ODBC connectivity and I am getting the below error. Not sure if its a DB2 issue or Datastage issue. I am new to DB2. DSR.MetaGeta(GET.DSNINFO)(SQLConnect('DB','userid')) : BCI Error : SQLSTATE=S1000,CODE=-567,[DataStage][SQL Client][ODBC][IBM(D...
- Wed Mar 10, 2010 9:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: need help in using the stored procedure stage
- Replies: 4
- Views: 4007
need help in using the stored procedure stage
How to use a STP Stage in DataStage Parallel Extender.