DSXchange

Hello: I am trying to implement some business rules within my ETL and the requirement is to pass a formula into the ETL upon runtime. The formula may change over time, for example we maintain a formula some where external to the ETL that defines the price - Price = x + 2.5 y and may change to Price ...

Hello:

Can you please help me find out the space utilized by an ETL on the unix box? In other words, if I create an ETL, how do I know the total space it has used?

Can I check the size of few files like RT_CONFIG, RT_LOG and find it out. I am not sure, please help.

Regards,
Bobby

StringToDate(InputLink.ColumnName,"%yyyy-%mm-%dd") and you have set the Datatype in the output of the Transformer as Date for this Column? Since you say that most of the rows are nulls, are you handling nulls? i thk it should be StringToDate(InputLink.ColumnName[2,11],"%yyyy-%mm-%dd&...

Can you post an example of how your input Date looks like and the derivation using StringtoDate type conversion? The Date from souce file looks like: -2006-01-01 and is defined as VarChar. On the insert I am using Enterprise stage on DB2 database which accepts the format as 2006-01-01. Thanks for y...

I am trying to pull from a sequential file to a DB2 table (DB2 Enterprise Stage): 1. File has char and date fields and "View Data" option works fine as long as I use the column format as VarChar. Most os the dates are NULL. 2. I am using StringToDate function for converting the VarChar Dat...

kcbland wrote:Sounds like the FTP ports are locked, you're going to have to talk to your network/NT administrator ...

Thank you Kenneth, I will talk to them and let you know about the results

kcbland wrote:Depends on your security requirements, some places use SFTP instead. Just try it, get the IP and give it a try.

I tried both FTP and SFTP and get the following error: "A remote host refused an attempted connect operation"

Thanks for your reply. Since I need to send the file from Unix to NT location, do I need some kind of FTP listner service running on NT side? Please advise. If you're just moving a file around don't use the FTP stage use command line FTP or SCP. That being said, a LAN is a physical server. You need ...

Hello:

I am creating a file on Unix box and want to know how can I setup the DataStage job to FTP the file to LAN.

Looks like FTP stage only supports FTP to a specified server only. Can you please help me with this.

Thanks
Bobby

Thank you so much for your extended help. There was an issue with my metadata and I fixed it after analyzing the XML file. Regards Bobby Hmmm... this is where it gets hard to help without actually being there. Is there anyone onsite there with you (even if they don't know DataStage) that knows XML a...

I am getting the following error: Xalan fatal error (publicId: , systemId: , line: 1, column: 11): The prefix 'rs' has not been mapped to any URI Looks like I have not imported the metadata correctly, please advise. Thanks. Sure... but have some patience, we're not all here online 24x7. This should ...

Can anyone help me understand what could be causing "zero rows" to be processed??

Thanks!!

Job is executing without any warning or errors now but it is processing zero rows. I am writing to a Sequential File and it is empty.

Please advise.

Thanks

1. Yes there is xmlns 2. Yes I included it in metadata import 3. I have loaded that in input stage now 4. I am using both folder stage and xml input stage. 5. Now I have checked on 'Include namespace declaration'. and done "Load" Can you let me know what should be my column names in the fo...

Hello I have already imported the metadata from the xml file via Manager. The XML file has definitions at the top and data in the bottom of the file (I am new to XML). Can you please let me know the namespace issue or any other thing I should look for. Thanks As a guess, your XPath expressions are w...