Search found 7201 matches

by admin
Thu Dec 26, 2002 7:48 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Variable length data records
Replies: 3
Views: 1334

As I recall, we had to FTP the mainframe dataset to our unix server as a binary image, and define the file as having no line termination characters. This left us with fixed-length records in the input file, but to a hex editor, it looked like one very looong record. Have you considered having the da...
by admin
Thu Dec 26, 2002 7:16 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Variable length data records
Replies: 3
Views: 1334

Himanshu Sometimes you need to convert from EBCDIC to ASCII ahead of time using the dd command if you are on a UNIX box. The packed fields can be unpacked with a oconv() call. I would have to look up the syntax on these commands to tell you exactly how to do it. Thanks Kim. Kim Duke DsWebMon - Contr...
by admin
Thu Dec 26, 2002 6:57 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Variable length data records
Replies: 3
Views: 1334

Variable length data records

Happy Holidays to all in the forum Has any user of DS ever written server jobs to process mainframe data downloaded to a server? If so has the data ever been variable length and included packed fields? If so, can someone outline how they did it, stages etc. Were encountering issues with these proces...
by admin
Thu Dec 26, 2002 6:55 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Variable length Mainframe data records
Replies: 0
Views: 444

Variable length Mainframe data records

Happy Holidays to all in the forum Has any user of DS ever written server jobs to process mainframe data downloaded to a server? If so has the data ever been variable length and included packed fields? If so, can someone outline how they did it, stages etc. Were encountering issues with these proces...
by admin
Thu Dec 26, 2002 1:41 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Using Parameter in Constraint....
Replies: 13
Views: 6601

This email chain is getting too long. Siva, you say below that all rows are being rejected and also written out the output link. Quote: " In the log it says all total rows are rejected but it loads all the records. " This implies that you have an output link AND a reject link with the reject check b...
by admin
Thu Dec 26, 2002 10:34 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Looping a job - STILL STUCK!
Replies: 6
Views: 1108

Is this is a 6.x feature or is it that we are missing some settings?? We are using DS5.1 on NT and I have to agree with Vicki on the points mentioned. YN --- Ray Wurlod wrote: > Server jobs are not available in the sequencer/job > control drop-down list until (a) the server job has > been compiled a...
by admin
Thu Dec 26, 2002 5:52 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Jeanice Hayslett/Towers/IPAPER is out of the office.
Replies: 0
Views: 408

Jeanice Hayslett/Towers/IPAPER is out of the office.

I will be out of the office starting 12/25/2002 and will not return until
12/30/2002.

I will respond to your message when I return.
by admin
Wed Dec 25, 2002 11:52 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Jeanice Hayslett/Towers/IPAPER is out of the office.
Replies: 0
Views: 367

Jeanice Hayslett/Towers/IPAPER is out of the office.

I will be out of the office starting 12/25/2002 and will not return until
12/30/2002.

I will respond to your message when I return.
by admin
Wed Dec 25, 2002 5:51 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Jeanice Hayslett/Towers/IPAPER is out of the office.
Replies: 0
Views: 386

Jeanice Hayslett/Towers/IPAPER is out of the office.

I will be out of the office starting 12/25/2002 and will not return until
12/30/2002.

I will respond to your message when I return.
by admin
Wed Dec 25, 2002 11:51 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Jeanice Hayslett/Towers/IPAPER is out of the office.
Replies: 0
Views: 349

Jeanice Hayslett/Towers/IPAPER is out of the office.

I will be out of the office starting 12/25/2002 and will not return until
12/30/2002.

I will respond to your message when I return.
by admin
Wed Dec 25, 2002 7:10 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Using Parameter in Constraint....
Replies: 13
Views: 6601

try printing your parameter to the log or a file and see what the value is that is being passed.... Siva_Hotmail wrote: >Hi Pavan, > >Yes I am using Constraint: Param1 = @TRUE > >Thanks >Siva > > >----- Original Message ----- >From: >To: ; >Sent: Tuesday, December 24, 2002 11:36 PM >Subject: RE: Usi...
by admin
Wed Dec 25, 2002 6:00 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Using Parameter in Constraint....
Replies: 13
Views: 6601

When you set the value of Param1, presumably in job control code, you use the expression Param1 = (DSLink3.Prod >= 15), though without the parentheses. Think about what is happening at this time. DSLink3 is unknown (it is within the controlled job). Therefore, the value of DSLink3.Prod is unknown, o...
by admin
Wed Dec 25, 2002 4:47 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Using Parameter in Constraint....
Replies: 13
Views: 6601

OK, that doesnt really tell me much more. You are going to have to move back to something like: Parameter: Param1 = 0 And constraint: DSLink1.Prod_ID > Param1 -----Original Message----- From: Siva_Hotmail [mailto:sivakumar_sr@hotmail.com] Sent: Wednesday, 25 December 2002 1:52 PM To: david@barham.hm...
by admin
Wed Dec 25, 2002 3:51 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Using Parameter in Constraint....
Replies: 13
Views: 6601

Hi David, Thanks for your email. What I am trying to do is. Like doing a dynamic validation when running a job. So, when running a job the value will be entered in the parameter and that parameter will be used to as constraint inside the transformation. Thanks Siva ----- Original Message ----- From:...
by admin
Wed Dec 25, 2002 3:29 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Using Parameter in Constraint....
Replies: 13
Views: 6601

Siva, Refer my previous posting. One has to ask why are you trying to pass a condition as a parameter. Maybe time to take a step back and think about what you are trying to achieve. If you could tell us in broader terms why you need to pass a condition to your job, we might be able to suggest altern...