DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 119 matches
Author Message
Resolved
 Topic: Sequence Job End of Month Date
jackson.eyton

Replies: 8
Views: 156

PostForum: General   Posted: Fri Oct 12, 2018 5:04 am   Subject: Sequence Job End of Month Date
Ray that is a great point, one that I have accounted for in a parallel job that does the same thing using a transform stage. I just overlooked that here. To be fair I AM using the MONTH.LAST now inste ...
Resolved
 Topic: Sequence job End of Quarter Date
jackson.eyton

Replies: 3
Views: 82

PostForum: General   Posted: Thu Oct 11, 2018 9:12 am   Subject: Sequence job End of Quarter Date
Oconv(QUARTER.LAST(Oconv(@DATE, "DY[4]") : "Q" : Oconv(@DATE, "DQ")),"D-YMD[4,2,2]")


Interesting.......
Resolved
 Topic: Sequence Job End of Month Date
jackson.eyton

Replies: 8
Views: 156

PostForum: General   Posted: Thu Oct 11, 2018 8:34 am   Subject: Sequence Job End of Month Date
Ray, that's interesting... It seems that MONTH.LAST/ConvertMonth() requires the external date string format, and the @DATE/@YEAR/@MONTH variables appear to be in internal format. Thus the only way I c ...
Resolved
 Topic: Sequence Job End of Month Date
jackson.eyton

Replies: 8
Views: 156

PostForum: General   Posted: Tue Oct 09, 2018 12:19 pm   Subject: Sequence Job End of Month Date
That is the default search setting for me so it would appear that I did.
Resolved
 Topic: Sequence job End of Quarter Date
jackson.eyton

Replies: 3
Views: 82

PostForum: General   Posted: Tue Oct 09, 2018 11:29 am   Subject: Sequence job End of Quarter Date
ok, never mind again.... I really didn't think this one through, got it after lunch...

Q1: Oconv(Iconv(@YEAR:"03":"31","D-YMD[4,2,2]"), "D-YMD[4,2,2]")
Q2: Oconv(Iconv(@YEAR:"06":"30","D-YMD[4,2,2 ...
Resolved
 Topic: Sequence job End of Quarter Date
jackson.eyton

Replies: 3
Views: 82

PostForum: General   Posted: Tue Oct 09, 2018 8:46 am   Subject: Sequence job End of Quarter Date
DataStage® Release: 11x
Job Type: Server
OS: Windows
Does anyone know how I would go about getting the end of quarter date for the current quarter? We have some processes that need to run a loop, once for just end of month, twice for end of month if tha ...
Resolved
 Topic: Sequence Job End of Month Date
jackson.eyton

Replies: 8
Views: 156

PostForum: General   Posted: Tue Oct 09, 2018 7:59 am   Subject: Sequence Job End of Month Date
Never mind, I got it!
Oconv(Iconv(@YEAR:@MONTH+1:"01","D-YMD[4,2,2]")-1, "D-YMD[4,2,2]")

Took a little help from here, found with google but not the internal search of the forum Question

http://ww ...
Resolved
 Topic: Sequence Job End of Month Date
jackson.eyton

Replies: 8
Views: 156

PostForum: General   Posted: Tue Oct 09, 2018 7:38 am   Subject: Sequence Job End of Month Date
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi everyone,
I'm hoping to use the UserVariables functions to calculate the end of month date for the current month. I found a routine by Ray that does some similar things that looks like it coul ...
 Topic: Netezza for loop
jackson.eyton

Replies: 2
Views: 95

PostForum: General   Posted: Thu Sep 27, 2018 2:56 pm   Subject: Netezza for loop
Opened a case with IBM after the one and only netezza specific forum based site I posted on got no response. Seems like a dead site.... Stack Exchange I suppose could work but I've never been a fan of ...
 Topic: Netezza for loop
jackson.eyton

Replies: 2
Views: 95

PostForum: General   Posted: Wed Sep 19, 2018 3:28 pm   Subject: Netezza for loop
DataStage® Release: 11x
Job Type: Server
OS: Windows
Additional info: NETEZZA
Hey guys, I have been reading up on for loops as I am hoping to simplify one of our cleanup tasks. I started reviewing here:
CREATE OR REPLACE PROCEDURE generateTime(integer)
LANGUAGE NZPLSQ ...
Resolved
 Topic: Set Parameter Value with Data Item
jackson.eyton

Replies: 5
Views: 558

PostForum: Cognos (IBM BI)   Posted: Fri Jul 06, 2018 7:32 am   Subject: Set Parameter Value with Data Item
I did in fact get a work around for this functioning. Basically I have a report that has a prompt to run one of a selection of report pages. The report pages use the same query but with different filt ...
Resolved
 Topic: Set Parameter Value with Data Item
jackson.eyton

Replies: 5
Views: 558

PostForum: Cognos (IBM BI)   Posted: Tue Jul 03, 2018 8:06 am   Subject: Set Parameter Value with Data Item
Mike,
I think our wires are crossed, or I am misunderstanding. I am referring to Cognos reports. In any case I think I found a way around what I was trying to do, many ways to skin the cat thankf ...
Resolved
 Topic: Set Parameter Value with Data Item
jackson.eyton

Replies: 5
Views: 558

PostForum: Cognos (IBM BI)   Posted: Mon Jul 02, 2018 2:43 pm   Subject: Set Parameter Value with Data Item
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi, I was curious about setting a parameter value using a Data Item. I have a report that I have created a Data Item that uses a CASE WHEN condition to try and set the value of ?myParam? parameter. Th ...
 Topic: Custom Parallel Stagetype - Wrapped
jackson.eyton

Replies: 8
Views: 927

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 14, 2018 9:32 am   Subject: Custom Parallel Stagetype - Wrapped
Any luck on this?
 Topic: CDC stage in Datastage 11.7
jackson.eyton

Replies: 10
Views: 1776

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 12, 2018 8:51 am   Subject: CDC stage in Datastage 11.7
Sorry to dig this back up but when I search for Change Data Capture stage all I get are documents referring to the Change Capture stage, which I am really hoping is different from the Change Data Capt ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours