DSXchange

Hi I need some help with date time arithmetic. I have read a lot of threads and read all about the various date and time functions but have not been able to figure out how to achieve what i need. My table has the following two fields - start_date start_time The initial date and time values will be p...

Thanks ArndW.

But one would still need to know the record length for all the different files that may come in via FTP.

I guess i will have to look at a non datastage solution.

Hi guys

Wondering if there is a way to FTP files, using FTP stages, without knowing anything about their internal structure ?

Ray - Thanks for pointing me in the right direction. Apparently the local repository and XMETA had gone out of sync which is probably why we were getting the error. I deleted the category containing the jobs from DS Designer and that i think deleted only the local unix files. Then after reading your...

Okay. Will do. But just for my knowledge, can you please let me know what is causing this error during import ? I even deleted the entire category in which these jobs are supposed to be imported into - so there is, theoretically, no trace of those jobs left in our target server and yet i am getting ...

Thanks Ray ...but we are on 8.1

Correct me If i am wrong, but I think SyncProject is available only on 8.5 and above.

Here is a strange problem that i am encountering and i'd appreciate if someone can help resolve it. I Export a bunch of jobs from server A. There are say 5 jobs. jobA jobB ... ... JobE. Then i try to Import them into Server B. While importing, i get error - jobA cannot be found in the repository. Sa...

Thanks for the reply.

I cannot even the director to set options. I believe the log is so huge and my director hangs up(Not Responding). Please let me if there are any alternative approaches.

Thanks.

Problem: I have a Master_Sequence with jobs A,B,C as follows.. Master_Sequence:A-->B-->C My sequence and jobs with in the sequence, run 50 times a day in parallel with different invocation ID's. Logs will be created as follows. Master_Sequence.1 Master_Sequence.2 Master_Sequence.3 . . . . . Master_S...

Thanks Ray but my Unix admin assures me that when he drops the image on this new server it will be the exact replica of the old server...same everything including machine name, ip address etc ...

Hi We have a datastage 8.1 installation on an AIX 6.1 machine which is actually a LPAR on an IBM P570 server. We are thinking of taking an image of our server which can be dropped on another server for the purpose of disaster recovery. Our fall back plan is to take weekly backups of the production p...

Yes.

Here is my design..

Source_DataSet-->Copy Stage-->DB2 Connector----RejectLink--->Sequential File---Reject Link---->Sequential File.

Thanks.

Hi Ray, Thanks for the reply. I tried having a reject link to the sequential file I'm trying to capture the reject records in to. I was unable the see the records except the error code which I have checked in the db2 connector stage. If I don't check either error code or error text, my view data is ...

I went through resolved topic How to Ouput Reject Records from DB2 Connector to Flat File. I could be missing something but, I'm unable captute actual records except error code and/or error text either dataset ot file. I have RCP enabled in my job and in administartor. Problem: 1. I have 10 records ...

Hi I need to flatten a mainframe like text file. There are 3 record types: Header (1st byte is an 'A') Segment (1st byte is a '$') Detail (1st byte is numeric) Input Axxxxxxx $yyyyyyy 01detaaa 02detbbb 03detccc Azzzzzzz $jjjjjjj 01detddd Desired Output Axxxxxxx$yyyyyyy01detaaa Axxxxxxx$yyyyyyy02detb...