DSXchange

I can assemble the date within datastage but if I can assemble the date in the query it would allow me to use the query to select only data that has changed in the last 30 days. Reading 4M rows to get the 1000 that changed seems clunky but perhaps that's what will have to be done. I thought the deri...

We use an ODBC Stage to connect to Datacom tables. Some date fields on the database are stored in 3 separate fields DT_YY, DT_MM, DT_DD. Is it possible to concatenate these fields in the select of the query? Tried DT_YY || DT_MM || DT_DD - failed, datacom doesn't like the || DT_YY + DT_MM + DT_DD - ...

I encountered this problem, searched DSX for help, and later fixed with assistance from our DBA. Here are his notes for resolution: When i searched for the at.exe, i found it in 3 different places. 1) C;\Windows\system32, 2) C:\Windows\ServicePackFiles\i386 and also at 3) C:\Windows\MKS Toolkit\bin....

This seems to work. While some of the status codes are for validation only, the objective here is that Zeke scheduler stops, operator notifies the programmer, and the programmer determines course of action. Anything other than 1 or 2 should generate a phone call. Code: IF ERRORLEVEL 99 GOTO Aborted ...

-jobstatus returns 1, 2, 3, etc. as expected. Now (at the risk of hijacking) I need to return a 0 to the scheduler if errorlevel is 1 or 2 and the errorlevel value if greater than 2. Have tried several things, and this is close as close as I've come, but the results are unexpected. IF ERRORLEVEL 1 S...

Thanks for the responses, cannot change the .cmd from home but will give it a go in the a.m.

Ray - I found the DataStage Basic and Server to Parallel DVD classes very helpful. Thanks for doing those.

.cmd file zeke executes looks like: call \\LMDSTAGE1MV.AAMHC.LOCAL\E$\Ascential\DataStage\Engine\bin\DSJOB -run -wait -param "param1=value1" -param "param2=value2" CF_WH_TEST CSS_ADDR_Control IF %ERRORLEVEL% EQU 0 goto end echo ============ >> e:\fail.txt echo failed >> e:\fail.t...

Thanks for the responses. Found the solution searching with DSJOB (much weeding though). Needed to get zeke to the datastage server \\DSServerDNS\E$\Ascential\DataStage\Engine\bin\dsjob -run -wait -param "param1name=param1value" -param "param2name=param2value" projectname jobname

Our company has installed a Zeke Agent on our test DataStage server and required that scheduling of jobs be handled through Zeke instead of the DataStage scheduler. I think I need to set up batch scripts that Zeke will use to pass parameters and execute DataStage sequences. Does anyone have any exam...

Thanks for replies.

Does anyone have thoughts on dumping all the mainframe data to a Staging Oracle DB and using DStage for capturing data changes vs the Production Oracle DB?

Pro or Con would be great.

On the Mainframe we currently extract data from various systems. The data is FTP'd to the host server, then the tables are truncated and reloaded. One suggestion is to compare the current mainframe extract with the previous extract to determine changes from cycle to cycle. Using the CDC files, a Dat...

Currently our company data from the mainframe each night, FTP's the data to a server at a remote location, then transforms and loads the data. Issues are the time it takes to run the cycle and the growing volume of data. Changed Data Capture seemed a viable alternative so I suggested it. My thought ...

ag_ram

Thanks for pointing that out. Not sure how I even got there. Probably landed there in a search and didn't realize I hadn't specified the forum.

Sorry!

A routine with something like this should work. InternalD = iconv(Arg1,"D4/MDY[2,2,4]") InternalT = iconv(Arg2,"MT") Ans = oconv(InternalD, "D4-YMD[4,2,2]"):' ':oconv(InternalT, "MT") Guru's may have something better but I think this will get the job done. Ric...

Currently our company extracts 6 billion bytes of data from the mainframe each night, FTP's the data to a server at a remote location, then transforms and loads the data. Issues are the time it takes to run the cycle and the growing volume of data. Changed Data Capture seemed a viable alternative so...