DSXchange

I am receiving the following error message when trying to promote using Version Control (v7.5.0, client v7.5.0.25): Run-time error '429' ActiveX component can't create object I have used VC for several months without a problem. What changed is we now have 2 projects with the same name on different s...

The CFF stage works as a source stage, but not a target. I am writing EBCDIC files in copybook format using the sequential file stage. It is not easy to handle 'depending on' clauses. I ended up using a static layout. DataStage does not have a routine to convert an ASCII number to COMP3. If you have...

I'm not sure it applies or not, but I've seen some unexpected job names show up on the Dependencies tab of a job. Have you checked there? Maybe VC is picking them up?
John

No doubt about it - it's Earn and Learn time... 1. you won't be able to use the CFF - it is only a source stage 2. you will need to learn about COBOL data. Here is a web site that has some good information: http://www.discinterchange.com/TechTalk_COBOL_comp_.html 3. use a HEX editor to look at the d...

I just confirmed that in 7.5, a user with the DS Operator role can only run 'released' jobs. They cannot even see other jobs including those that were promoted as read-only by Version Control. Seems like an oversight on Ascential's part.
John

Are you saying a DS Operator can't run jobs that are promoted with Version Control? That seems like a big mistake by Ascential. I'm going to have to investigate it further...
Thanks,
John

I am testing the DataStage security settings, specifically the DataStage Operator role. Here is my configuration: I have added a local Windows user "ds_test" to the server. I have added a local Windows group "AAU_OPERATOR" and added the ds_test user. ds_test is a member of Users,...

I have read various excellent postings about read and write caching of hashed files. Thank you all for sharing your knowledge! I have one area that I would like feedback on: I would expect write caching to follow this behavior: write to cache until full, write to disk, resume writing to cache, write...

Within a transformer you can select the columns on the left and drop them on the Column Name portion of a link on the right. This will result in the output columns being populated.

Is this what you mean?

John

First - the solution you asked for is: "DYMD[4'',2'',2]" [Two single quotes next to each other, following the 4 and the first 2] This says you want nothing as the delimiter. As others have said, I think you are wanting OCONV, not ICONV. Second - please tell us more of what you are doing. W...

It seems the only difference is the time of day, so I would look at other applications that might be running at night: backup software, virus scans, automatic Windows updates...

Hope this helps,
John

Have you verified that the Length and Display values of the 15 columns in the sequential file are the same? DataStage is going to use the Display values to write the record. Also, your numbers don't look right - 925 isn't evenly divisible by 15 even if you're including a line terminator.

John

Is Field 2 a multi-valued field, like from a Universe database? The Universe stage allows you to "Normalize" on a multi-valued field. This method allows you to handle a varying number of values in Field 2 (which is what I think you mean when you say 'dynamic').

Hope this helps,
John

I think I understand - you are currently getting a NULL (not found) and you should be getting a hit (found)? I would use the Index function. Here is some documentation from BASIC.pdf: Syntax INDEX (string, substring, occurrence) Description Use the INDEX function to return the starting character pos...

Do you know that the xxx in the dialog box refers to FILENAME? I'm wondering if it could be referring to the logfile (maybe it isn't closing properly so it can't be overwritten). I would change the single > to >> (which appends to the existing file) and try again. Also, welcome to the forum! John