I am currently using Datastage 7.5.1.A, our database is DB2 UDB v 8.1.2 and our server is UNIX. Currently I have a script in Unix that is called in a datastage execute command stage with three parameters. The truncate works but what I would like to do is pass another parameter so that I might be...
Hello,
I am working in datastage 7.5.1A and we have jobs that use a view to lookup into a Preload table and also looks at the actual table that we are going to be loading every week. We are using it like a hash because it has been quicker. The problem we are coming across is that every time we...
I have a table that has NODE_ID, NODE_NAME, IP_Address, EVENT_TYPE, EVENT_Name FROM the NODE_Events table. Each of these nodes has several events that happen. for example Event_Type = 5 is Node Down or Event_Type = 1 is Node UP. So there may be several of these per node and I want to count those...
Here we go I have two views that I created and one is for node_up the other is for node_down. What this is doing is calling from a syslog table all the nodes that are up in one view and all the nodes that are down in the other. the way the table works is that if a node goes down...
Hi I have a special query thats been requested of me and it invloves a single table that is producing a repetative result. What Im looking to do is merge the repetative records reducing the redundant data to one record and any columns that are not redundant be given their own column alias.
For...
We are sitting on a UNIX server and we have most files going to a specific directory in this platform for datastage. So in essence I need to define a DSN to the server(tstetl02) so that designer will be able to read in the database
I'm new to datastage and I am trying to figure out how to load a sequential file into an MS Access Database. I have no problem setting up the sequential file and data definitions and loading the data there. My problem comes about when I'm trying to open the Target stage and specify the data...
We have a production enviroment setup with Webi 5.1.7. I am able to edit a query and add a field and when I hit the run button it shows the new field I added.
Unfortunately in 6.5.1 when I go to edit a query and add a field and then run that query it shows the old query without the new field. I...
I just have one question...If I have a combo box in asp and it has a list of values from a system like primavera's database reporting system. Can I input new values by simply typing in what needs to be stored instead of choosing from a predefined list...Thanks in advance....
Got it working, the only thing you didn't account for was the AM so the length was actually 21 not 19, but it was a wonderful help, would have never thought of that, thanks again.
I do not have a displace button to press when I go into the menu. Is there any other button that I can push or use.
Sorry for the bother thanks for all the help, this has been giving me trouble since I started it.
So far that I know that worked because I didn't get any errors the only problem is that when I try to drag the second variable on to the report I get a blank cell. I am new with using variables in business objects so I'm not sure if I have to have a cell already setup or should I just be able to...
=FormatDate(UserResponse ("Query 1 with AIS-MQR1" , "Type Begin Date") ,"mm/dd/yyyy")
This is the statement I put in and I'm getting and incorrect data type error. It highlights the comma right before the string format. Not sure why it won't allow this variable to work.
I have a report that is created off of date prompts. Unfortunately those date prompts are a date and a timestamp. I want to show just the date prompt. The dates are prompted as Begin Date and End date I want to be able to show both. Below is an example of what I have on the report.
1/24/2004...
I am working with Business Objects 5.1 and I am trying to prompt between two dates. I first had to convert the date so that it could be typed into a prompt as mm/dd/yyyy. That has worked fine. The problem I'm having is that every time I prompt for the date it doesn't return any specific data. I...
I am working in Business Objects and creating reports through prompting for dates. I want to be able to prompt for reports using the format mm/dd/yyyy. I am pulling from Oracle tables and the date format is shown like this DD-Mon-RRRR.
I have brought the SQL from Business Objects and put it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.